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

From: "Vijayakumar" <mails4vijayakumar(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5847: pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0x96
Date: 2011-01-25 04:18:24
Message-ID: 201101250418.p0P4IOvv067349@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message SETU SAXENA 2011-01-25 06:31:06 A bug to report
Previous Message Tom Lane 2011-01-25 00:12:12 Re: BUG #5846: Segfault Postgresql Built with --lib-libedit-preferred