Postgres Pro
Downloads
Home   >   mailing lists

Re: upgrade from 7.4 to 8.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: upgrade from 7.4 to 8.3
Date
Msg-id 29868.1236704216@sss.pgh.pa.us
Whole thread Raw
In response to upgrade from 7.4 to 8.3  (Marc Cuypers <m.cuypers@mgvd.be>)
Responses Re: upgrade from 7.4 to 8.3  (Marc Cuypers <m.cuypers@mgvd.be>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Marc Cuypers
Date:
Subject: upgrade from 7.4 to 8.3
Next
From: Karsten Hilbert
Date:
Subject: Re: upgrade from 7.4 to 8.3