Thread: pg_restore error
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? Thx in advance /Kevin
Am Donnerstag, 13. Dezember 2007 18.06:23 schrieb Kevin Kempter: > 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 > --------------------------------------------------------------------------- >------------------------------ I got similar messages for several reasons: -Restore of data dump from an older server version on a newer one. The UTF8 handling was changed several times, where mostly the older servers did accept worng byte codings which newer servers do not anymore. -The server was created with an other encoding then the one which created the dump. -The dump was edited and with it some wrong encodings did enter. If you could provide some more details what happened I might come up with some more ideas. Best regards Ivo > > > Any thoughts? > > > Thx in advance > > /Kevin > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq
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