How to get PostgreSQL working on a Ubuntu 12.04 Server (Precise Pangolin) Vagrant box

gistfile1.md

Set some locale configs:

sudo locale-gen en_US en_US.UTF-8 
sudo dpkg-reconfigure locales
sudo update-locale LANG=en_US.UTF-8
sudo update-locale LANGUAGE=en_US.UTF-8
sudo update-locale LC_ALL=en_US.UTF-8

Login and logout from the VM and recreate the cluster:

sudo pg_dropcluster --stop 9.1 main
sudo pg_createcluster --start 9.1 main

Voilà!