Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore error - Mailing list pgsql-admin

From Usama Dar
Subject Re: pg_restore error
Date
Msg-id ff0e67090712161205l5858eb72k48d13663840ffb6a@mail.gmail.com
Whole thread Raw
In response to pg_restore error  (Kevin Kempter <kevin@kevinkempterllc.com>)
List pgsql-admin
Tree view


On Dec 13, 2007 10:06 PM, Kevin Kempter <kevin@kevinkempterllc.com> wrote:
Hi list;

We're seeing this error whern trying to restore a pg_dump file:

---------------------------------------------------------------------------------------------------------
pg_restore: ERROR:  invalid byte sequence for encoding "UTF8": 0x9f CONTEXT:
COPY log_customer_api, line 4551 pg_restore: [archiver (db)] error returned
by PQendcopy: ERROR:  invalid byte sequence for encoding "UTF8": 0x9f
CONTEXT:  COPY log_customer_api, line 4551 pg_restore: *** aborted because of
error
---------------------------------------------------------------------------------------------------------


Any thoughts?


Which version are you trying to restore into? Which version did you dump from?

--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar

pgsql-admin by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: sequence owned by backwards compatability
Next
From: "Scott Marlowe"
Date:
Subject: Re: reading pg_stat_activity view