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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
