Postgresql 9.2 installation on Ubuntu 12.04 Postgresql 9.2 installation on Ubuntu 12.04 postgresql postgresql

Postgresql 9.2 installation on Ubuntu 12.04


I tried all of the solutions that I could find, but in the end this post sorted it:

http://ubuntuforums.org/showthread.php?t=1720356

Basically, add the language you want to /etc/environment. In my case:

sudo nano /etc/environment

Then added this to the end of the file:

LC_ALL="en_US.utf-8"

Then reboot the server

sudo reboot


Your system locale configuration is messed up. Your LC_MESSAGES is set to en_IN.UTF-8 but LANG is set to en_US.UTF-8 which is weird and inconsistent. Did you set LC_MESSAGES in your ~/.bash_profile, /etc/environment or something?

You really should dpkg-reconfigure locales. See how to select and generate locales in Ubuntu.

Once you've fixed your locale setup, you can use the pg_wrapper command pg_createcluster 9.2 main --start as suggested by the error to create the cluster. After that, starting the service will work.