From: | Marc Cuypers <m(dot)cuypers(at)mgvd(dot)be> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | upgrade from 7.4 to 8.3 |
Date: | 2009-03-10 16:02:59 |
Message-ID: | 49B68F33.9080707@mgvd.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I've just upgrade postgresql from 7.4 to 8.3 on a machine running debian.
And i ran in trouble. I've searched the internet but didn't find an
answer to my solution.
Is it possible to upgrade from 7.4 to 8.3 at once?
I upgraded as follows:
when 7.4 was installed i dumped the data with:
su postgres -c "pg_dumpall --create" > out
when 8.3 was installed i imported the data with:
su postgres -c "psql < out"
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.
When creating a database from pgadmin (logged in as postgres) with:
CREATE DATABASE "db" WITH OWNER = postgres TEMPLATE = template0 ENCODING
= 'UNICODE'
postgres replies with:
ERROR: encoding UTF8 does not match server's locale en_US
DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
********** Error **********
ERROR: encoding UTF8 does not match server's locale en_US
SQL state: XX000
Detail: The server's LC_CTYPE setting requires encoding LATIN1.
Can anybody tell me what's wrong?
--
Best regards,
Marc
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Wenk | 2009-03-10 16:16:58 | Re: bug?: permission denied for schema on "on delete set null" |
Previous Message | JP Fletcher | 2009-03-10 15:33:38 | Re: postgresql and LDAP |