From: Naomi Walker <nwalker@eldocomp.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Restore Problem
Date: Mon, 20 Oct 2003 11:38:52 -0700
Message-ID: <5.1.0.14.2.20031020113413.028d0a98@imap.eldocomp.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

At 09:40 AM 10/20/2003, Tom Lane wrote:
>"Monica Robustelli" <monica_robustelli@hotmail.com> writes:
> > If I transfer the backup file to another Linux machine, Red Hat 9,=20
> 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).

What then is the proper method of upgrading from and old release?  I was=20
planning on :

pg_dumpall > alldata.sql
psql -f alldata.sql template1 postgres >&err.out&


-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to w=
hom it is addressed, and may contain information that is privileged, confid=
ential and exempt from disclosure under applicable law. If you are not the =
intended addressee, nor authorized to receive for the intended addressee, y=
ou are hereby notified that you may not use, copy, disclose or distribute t=
o anyone the message or any information contained in the message. If you ha=
ve received this message in error, please immediately advise the sender by =
reply email, and delete the message. Thank you.