upgrade from 7.4 to 8.3
От | Marc Cuypers |
---|---|
Тема | upgrade from 7.4 to 8.3 |
Дата | |
Msg-id | 49B68F33.9080707@mgvd.be обсуждение исходный текст |
Ответы |
Re: upgrade from 7.4 to 8.3
Re: upgrade from 7.4 to 8.3 |
Список | 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
В списке pgsql-general по дате отправления: