From: Popovici Alexandru <axa2001ro@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: invalid byte sequence for encoding "UNICODE":0xa1
Date: Fri, 4 Jan 2008 06:58:23 -0800 (PST)
Message-ID: <777993.26386.qm@web90503.mail.mud.yahoo.com> (raw)
Hello,
For my database ( PostgreSQL 8) I made a backup (
using pgAdmin ). Now when I try to restore the data (
again using pgAdmin ) at some point the process is
aborted:
-----------
pg_restore: ERROR: invalid byte sequence for
encoding "UNICODE":0xa1
CONTEXT: COPY ...............
pg_restore: [archiver(db)] error returned by
PQendcopy: invalid byte sequence for encading
"UNICODE":0xa1
CONTEXT: COPY ...............
pg_restore: *** aborted because of error
Process returned exit code 1
-----------
If I delete the database and restore only the
schema I get this message:
-----------
"WARNING: errors ignored on restore:21
Process returned exit code 1"
-----------
The designer of database has told me that this last
message is OK, and this is the message which should I
get after restoring the schema and data.
I have asked him why I can restore the data but
unfortunatelly he doesn't now where the problem is.
The database is installed on a server with Windows
2003 .
Can you please help me?
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: axa2001ro@yahoo.com
Subject: Re: invalid byte sequence for encoding "UNICODE":0xa1
In-Reply-To: <777993.26386.qm@web90503.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox