On 6 May 2011, at 16:19, Alan Hodgson wrote: > On May 6, 2011, Iain Barnett <iainsp...@gmail.com> 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
