From: | JP Glutting <jpglutting(at)oqua(dot)udl(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Error backing up database (Unicode) |
Date: | 2006-03-27 10:43:24 |
Message-ID: | 4427C1CC.5080801@oqua.udl.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
____________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Ashley Moran | 2006-03-27 10:44:00 | What to index to speed up my UNION views? |
Previous Message | Martijn van Oosterhout | 2006-03-27 09:48:29 | Re: case insensitive match in unicode |