Re: Restore Problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: Restore Problem
Date
Msg-id 3384.1066668047@sss.pgh.pa.us
Whole thread Raw
In response to Restore Problem  ("Monica Robustelli" <monica_robustelli@hotmail.com>)
List pgsql-admin
"Monica Robustelli" <monica_robustelli@hotmail.com> writes:
> If I transfer the backup file to another Linux machine, Red Hat 9, Postgres
> 7.3, I'v some problem during the database restoring. The error is:

> ERROR:  copy: line 13, CopyReadAttribute: end of record marker corrupted

A likely bet is that you transferred the dump file in a manner that
converted Unix newlines (\n) to Windows newlines (\r\n).  COPY does not
tolerate that (in releases before 7.4 anyway).

            regards, tom lane

pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: postgresql having trouble under load
Next
From: Kris Kiger
Date:
Subject: ERserver problems