Re: upgrade from 7.4 to 8.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Cuypers <m(dot)cuypers(at)mgvd(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: upgrade from 7.4 to 8.3
Date: 2009-03-10 16:56:56
Message-ID: 29868.1236704216@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Cuypers <m(dot)cuypers(at)mgvd(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2009-03-10 17:05:04 Re: upgrade from 7.4 to 8.3
Previous Message Andreas Wenk 2009-03-10 16:16:58 Re: bug?: permission denied for schema on "on delete set null"