Initialising a PostgreSQL database cluster for use in Great Britian

After installing PostgreSQL the database cluster will need to be initialised. By default this will use a American locale (en_US) which includes settings such as date formatting and currency. If the cluster is to be used in the United Kingdom setting the locale to use UTF8 makes more sense.

This can be done as follows:

initdb  -D /var/lib/pgsql/data  --locale en_GB.utf8

Last updated: 07/08/2013