Re: Locale and UTF8 for template1 in 8.4.4

[Iain Barnett <iainspeed@xxxxxxxxx>]

On 6 May 2011, at 16:19, Alan Hodgson wrote:

On May 6, 2011, Iain Barnett <iainspeed@xxxxxxxxx> wrote:

> Would anyone be able to point out to me how I can get the template1

> database to be utf8 and en_GB? (or US, I'm not *that* fussed)

Use the --encoding and --locale options to initdb.

I had to backup the PGDATA directory, but it worked. This is what I ran:

    initdb --encoding=UTF8 --locale=en_GB -D /path/to/data/dir

Thanks for the help, it is much appreciated.

Regards,

Iain