Error backing up database (Unicode)

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
____________________________________________________

Browse pgsql-general by date

  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