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

El 25/01/2011 2:18, Vijayakumar escribió:
> 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.
>
Hola a todos, la base de donde la respaldastes la tenias en utf-8,
win1252, sql_ascii o latin1?
Si aun tenes la base original proba pg_dump -Ft -EUTF8

saludos Fernando