Re: BUG #5847: pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0x96

On Mon, Jan 24, 2011 at 11:18 PM, Vijayakumar
<mails4vijayakumar(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5847
> Logged by:          Vijayakumar
> Email address:      mails4vijayakumar(at)gmail(dot)com
> PostgreSQL version: 8.2
> Operating system:   windows
> Description:        pg_restore: [archiver (db)] COPY failed: ERROR:  invalid
> byte sequence for encoding "UTF8": 0x96
> Details:
>
> while restoring my database i am getting the error as
>
>
>
> D:\EnterpriseDB\Postgres\8.2\bin\pg_restore.exe -i -h localhost -p 5432 -U
> postgres -d asasas -v "E:\backupcsv\erode.backup"
> pg_restore: connecting to database for restore
> pg_restore: creating TABLE generalledgermaster_erode
> pg_restore: restoring data for table "generalledgermaster_erode"
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 1624; 0 121663 TABLE DATA
> generalledgermaster_erode postgres
> pg_restore: [archiver (db)] COPY failed: ERROR:  invalid byte sequence for
> encoding "UTF8": 0x96
> HINT:  This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
> CONTEXT:  COPY generalledgermaster_erode, line 374
> pg_restore: creating CONSTRAINT generalledgermaster_erode_pkey
> pg_restore: setting owner and privileges for TABLE
> generalledgermaster_erode
> pg_restore: setting owner and privileges for CONSTRAINT
> generalledgermaster_erode_pkey
> WARNING: errors ignored on restore: 1
>
> Process returned exit code 1.

You haven't provided a whole lot of information to go on, here - but
apparently you have some invalidly encoded data in your dump file.
Older versions of PostgreSQL weren't as strict about preventing such
data from creeping into the database, which can lead to problems of
this type. Your best bet is to probably edit the dump before
restoring it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company