Re: [GENERAL] pg_dump generating unrestorable data (8.4)

2011-04-06 Thread Eric McKeeth
On Sun, Apr 3, 2011 at 12:49 PM, Glenn Maynard wrote: > After dumping a database (pg_dump -F c database > dump), trying to restore > it (pg_restore dump) gives: > > > pg_restore: [archiver (db)] Error from TOC entry 2463; 0 58451 TABLE DATA > table user > > pg_restore: [archiver (db)] COPY failed

[GENERAL] pg_dump generating unrestorable data (8.4)

2011-04-03 Thread Glenn Maynard
After dumping a database (pg_dump -F c database > dump), trying to restore it (pg_restore dump) gives: > pg_restore: [archiver (db)] Error from TOC entry 2463; 0 58451 TABLE DATA table user > pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0xe3273a > HIN