I'm having the next problem with the BYTEA field types, when I try to restore data into a new database from another postgres database (same version, 7.2).
ERROR: Invalid UNICODE character sequence found (0xed5c30) pg_restore: [archiver (db)] could not execute query: ERROR: Invalid UNICODE character sequence found (0xed5c30) pg_restore: *** aborted because of error
I'm running postgres in a Windows XP Pro system under Cygwin.
The dump command that I was run is (I also need export BLOB fields) (This server is a Linux RedHat 7.3 with Postgres 7.2 system):
pg_dump -h 172.16.10.2 -Ft -b -D "databasename" > "databasename".dmp
The sequence of actions that I'm doing are: (This another server is a Windows XP Pro with Cygwin+Postgres 7.2 system)
dropdb "databasename"
createdb -E UNICODE -T template0 "databasename"
pg_restore.exe -Ft -v -d "databasename" "databasename".dmp
