dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline" - Mailing list pgsql-general

From Ron Mayer
Subject dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"
Date
Msg-id POEDIPIPKGJJLDNIEMBEKELGCKAA.ron@intervideo.com
Whole thread Raw
In response to Re: Bug(?) with cursors using aggregate functions.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Sergey Holod
Date:
Subject: Making "SECURITY DEFINER" procedures
Next
From: "Jim C. Nasby"
Date:
Subject: ERROR: ExecutePlan: (junk) `ctid' is NULL!