From: | "Ron Mayer" <ron(at)intervideo(dot)com> |
---|---|
To: | "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
Cc: | <ron(at)intervideo(dot)com> |
Subject: | dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline" |
Date: | 2003-04-29 20:44:43 |
Message-ID: | POEDIPIPKGJJLDNIEMBEKELGCKAA.ron@intervideo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Holod | 2003-04-29 20:51:32 | Making "SECURITY DEFINER" procedures |
Previous Message | scott.marlowe | 2003-04-29 20:19:28 | Re: qsort (was Re: Solaris) (fwd) |