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
