On 6 May 2011, at 16:19, Alan Hodgson wrote:
> On May 6, 2011, Iain Barnett <iainspeed(at)gmail(dot)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