invalid byte sequence for encoding "UNICODE":0xa1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux