Something like pg_dump for 7.4
От | Gregory S. Williamson |
---|---|
Тема | Something like pg_dump for 7.4 |
Дата | |
Msg-id | 71E37EF6B7DCC1499CEA0316A2568328024BBF9D@loki.wc.globexplorer.net обсуждение исходный текст |
Ответы |
Re: Something like pg_dump for 7.4
|
Список | pgsql-admin |
I am trying to migrate a modest sized database (the unload file is just under a gigabyte) which is moderately complex, usingschemas and the like from 7.4 to 8.1 Alas, pg_dump appears to incompatable with my needs as it keeps introducing invalid UTF-8 characters. I have gone back and changed the offending data rows with SQL to make damned sure there are no illegal characters. I redump,compress the thing, scp it and try to reload. Same error every time: psql:glacier_load.sql:1017: ERROR: invalid UTF-8 byte sequence detected near byte 0x96 CONTEXT: COPY clients, line 1751, column client_name: "XYZ Media AB&E" psql:glacier_load.sql:3019: ERROR: current transaction is aborted, commands ignored until end of transaction block See that double space after "Media" ? That's actually a single space, a dash, and another space: "XYZ Media - AB&E", butevery export turns it into: XYZ Media <96> AB&E Is there any way to do this ? I can't edit the resulting dump file by hand -- it's huge. And pg_dump on 7.4 does not knowhow to a table inside a schema -- it seems to be all or nothing. TIA, Greg Williamson DBA GlobeXplorer LLC
В списке pgsql-admin по дате отправления: