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.