| From: | Matt Doughty <mdoughty(at)japan(dot)ea(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | failed import |
| Date: | 2002-12-17 07:38:27 |
| Message-ID: | 20021217073827.GG21612@japan.ea.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Howden | 2002-12-17 09:22:17 | Is is possible to persuade the query planner that ~* operations are grossly expensive? |
| Previous Message | Rajesh Kumar Mallah. | 2002-12-17 05:17:01 | Re: hello gurus |