Search Postgresql Archives

Re: Locale and UTF8 for template1 in 8.4.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]




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

[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux