Marc Cuypers <m.cuypers@xxxxxxx> writes: > Databases in 7.4 were encoded as utf-8. Now when importing postgresql > gives the following error: > ERROR: encoding UTF8 does not match server's locale en_US > DETAIL: The server's LC_CTYPE setting requires encoding LATIN1. It looks like you need to run initdb with LANG set to en_US.utf8, not just en_US. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general