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
