Re: BUG #4328: help in creating database encoded with LATIN1

andrew victoria wrote:

> i got an error message
> createdb: database creation failed: ERROR:  encoding LATIN1 does not match
> server's locale en_US.utf8
> DETAIL:  The server's LC_CTYPE setting requires encoding UTF8.
>
> when im trying to create a database encoded with LATIN1 which is needed in
> our work. what will i do?

You need to run initdb again, specifying --locale=en_US.  You can't
create a database whose encoding does not match the locale used by
initdb.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support