Hi guys I have searched the archives, and am out of ideas. I am trying to
migrate a database that is EUC_JP encoded, and has large objects from 7.1
to 7.2.2. I used pg_dump -Fc -b to dump the database, and then I used
pg_restore -d <database> <dump_file>, but it is dying mid import with the
following error:
pg_restore: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_announce_id' for table 'store_announce'
ERROR: copy: line 4, Invalid EUC_JP character sequence found (0x927c)
FATAL 1: Socket command type 1 unknown
pg_restore: [archiver (db)] error returned by PQputline
Anyone, with any clue here please let me know. I will be eternally grateful. :)
--Matt