Re: Restore Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Monica Robustelli" <monica_robustelli(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restore Problem
Date: 2003-10-20 16:40:47
Message-ID: 3384.1066668047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Monica Robustelli" <monica_robustelli(at)hotmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kris Kiger 2003-10-20 16:43:00 ERserver problems
Previous Message scott.marlowe 2003-10-20 16:13:14 Re: postgresql having trouble under load