Postgresql – Incomplete installation with unsupported locale


I was installing postgresql on Ubuntu 12.04 (Digital Ocean droplet). The locale variables in my environment gets transported to the DO box.

When postgres is installed via apt-get install postgresql, it appears to succeed. However no default cluster is created, and postgresql is not added as a service. This happens silently. I realised what was going on when attempting to run pg_createcluster manually failed.

Some questions arising from this:

  • how can I be alerted that the install hooks aren't being run?

  • after fixing the locale, I removed (and purged) the postgresql package; however the default cluster still wasn't created. What was preventing this? How can I ensure that install hooks are being run?

Best Answer

Install the package locales-all and your postgresql will start up.