On 6 May 2011, at 16:19, Alan Hodgson 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