Postgresql – Incomplete installation with unsupported locale

postgresqlUbuntu

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.

Related Solutions

Postgresql – Confused over encoding/locale in postgresql

The encoding defines the very basic rules how characters are represented in binary format (like @a_horse explains in his comment). It should be mentioned that the server encoding has to match the client encoding for successful communication. Postgres can translate if necessary, there is a dedicated setting client_encoding for this.

The locale is a superset of settings, which can be split up for PostgreSQL into

LC_COLLATE
LC_CTYPE
LC_MESSAGES
LC_MONETARY
LC_NUMERIC
LC_TIME

The settings of particular interest for you are LC_COLLATE (defines how strings are sorted) and LC_TYPE (defines the type of characters).
In older versions, these two settings could not be changed after a database had been initialized. Since Postgres 9.1 you can at least override the collation setting when needed.

PostgreSQL – Solving Issues with pgpoolAdmin Installation

You have SELinux enabled, and your policy doesn't allow Apache to write to those files.

Adjust the policy, relabel the files, or (not recommended) disable SELinux. The sealert can help provide guidance.

Best Answer

Related Solutions

Postgresql – Confused over encoding/locale in postgresql

PostgreSQL – Solving Issues with pgpoolAdmin Installation

Related Question