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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
