dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"
От | Ron Mayer |
---|---|
Тема | dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline" |
Дата | |
Msg-id | POEDIPIPKGJJLDNIEMBEKELGCKAA.ron@intervideo.com обсуждение исходный текст |
Ответ на | Re: Bug(?) with cursors using aggregate functions. (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"
|
Список | pgsql-general |
Should I expect to be dump/restore from 7.2 to 7.4devel to work cleanly? Of course it's perfectly OK if the answer is "not surprising on a devel build" :-) -- just letting people know. To dump I used: pg_dump -O -v -h 192.168.50.90 -F c -U logs logs2 -f /mnt/data1/tmp/logs2.dmp from the new machine with a couple-day-old CVS-tip. The old machine (192.168.50.90) is running 7.2. To restore I tried both pg_restore --no-acl -O -v -U logs -d logs2 < /mnt/data1/tmp/logs2.dmp which gave me pg_restore: restoring data for table d_ref pg_restore: [archiver (db)] error returned by PQputline pg_restore: *** aborded because of error and pg_restore --no-acl -O -v -U logs < /mnt/data1/tmp/logs.dmp | psql logs2 logs which gave me ERROR: CopyReadAttribute: Literal carriage return data value found in input that has newline termination; use \r CONTEXT: COPY FROM, line 1605109 Ron
В списке pgsql-general по дате отправления: