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
____________________________________________________
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
