Trying to do pg_restore from one UTF8 encoded db to another UTF8 encoded db
DB_source:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
psql 8.2.4
DB Destination:
Debian GNU/Linux 4.0
psql 8.1.9
I've tried:
pg_dump from the source box & from destination box
from destination server
pg_dump -i -h source_server db > db.8.1.9.sql
No matter which way I issue pg_dump command it always fails on the same record.
ERROR:
pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0xdf69
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 logs, line 69238382
pg_restore: [archiver (db)] error returned by PQendcopy: ERROR:
invalid byte sequence for encoding "UTF8": 0xdf69
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 logs, line 69238382
UTF8 to UTF8 and everything in between is UTF8, and it still fails,
I'm tempted to delete this record and keep going but I'm determined
to find a solution.
TIA for any help,
Jesse Waters