Error backing up database (Unicode)
От | JP Glutting |
---|---|
Тема | Error backing up database (Unicode) |
Дата | |
Msg-id | 4427C1CC.5080801@oqua.udl.es обсуждение исходный текст |
Список | pgsql-general |
I get this error when trying to back up a database in Postgres 8.1 that I was able to back up from Postgres 8.0 and restore into Postgres 8.1: C:\Archivos de programa\PostgreSQL\8.1\bin\pg_dump.exe -i -h localhost -p 5432 -U z2233935 -F c -b -v -f "C:\Documents and Settings\z2233935\db_test_io.backup" test_io pg_dump: reading schemas pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined conversions pg_dump: reading user-defined tables pg_dump: reading table inheritance information pg_dump: reading rewrite rules pg_dump: reading type casts pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: finding the columns and types of table "pg_logdir_ls" pg_dump: finding the columns and types of table "udl_anysxcentres_cols" pg_dump: flagging inherited columns in subtables pg_dump: reading indexes pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading dependency data pg_dump: saving encoding pg_dump: saving database definition pg_dump: dumping contents of table udl_anysxcentres_cols pg_dump: ERROR: could not convert UTF8 character 0x00e2 to ISO8859-1 pg_dump: SQL command to dump the contents of table "udl_anysxcentres_cols" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: could not convert UTF8 character 0x00e2 to ISO8859-1 pg_dump: The command was: COPY public.udl_anysxcentres_cols (centres, "1992", "1993", "1994", "1995", "1996", "1997", "1998", "1999", "2000", "2001", "2002", codi_udl_centre, "2003", "2004", "2005") TO stdout; pg_dump: *** aborted because of error Process returned exit code 1. I have posted a copy of the backup file of the table on this list. Has no one seen this error before? It seems very unlikely that this is the case, since a lot of people are using both WinXP and Unicode. Thanks, JP -- ____________________________________________________ Oficina de Qualitat Tel: 973 703 103 Universitat de Lleida Fax: 973 702 036 Pl. Víctor Siurana, 1 25003 Lleida ____________________________________________________
В списке pgsql-general по дате отправления: