The following bug has been logged online: Bug reference: 5847 Logged by: Vijayakumar Email address: mails4vijayaku...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs