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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
