The following bug has been logged online:
Bug reference: 5847
Logged by: Vijayakumar
Email address: mails4vijayakumar@gmail.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.