Re: upgrade from 7.4 to 8.3

Marc Cuypers <m.cuypers@mgvd.be> 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