From: Ivo Rossacher <rossacher@bluewin.ch>
To: pgsql-admin@postgresql.org
Subject: Re: pg_restore error
Date: Thu, 13 Dec 2007 21:10:19 +0100
Message-ID: <200712132110.19284.rossacher@bluewin.ch> (raw)
In-Reply-To: <200712131006.23925.kevin@kevinkempterllc.com>
References: <200712131006.23925.kevin@kevinkempterllc.com>
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
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: rossacher@bluewin.ch
Subject: Re: pg_restore error
In-Reply-To: <200712132110.19284.rossacher@bluewin.ch>
* 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