invalid byte sequence for encoding "UNICODE":0xa1

From: Popovici Alexandru <axa2001ro(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: invalid byte sequence for encoding "UNICODE":0xa1
Date: 2008-01-04 14:58:23
Message-ID: 777993.26386.qm@web90503.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message James Cloos 2008-01-04 15:35:59 Re: When does VACUUM FULL not clean out all deleted data?
Previous Message Suresh Gupta VG 2008-01-04 11:24:37 Need source for Solaris 9