pg_restore 7.4 from 7.2.1

From: Uwe Maiwald <u(dot)maiwald(at)kiss-net(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_restore 7.4 from 7.2.1
Date: 2003-11-28 13:03:24
Message-ID: 5.2.1.1.0.20031128133735.00a7ee60@mx0.kiss-net.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

i get errors restoring a 7.2.1 dump into 7.4

the commands were

Version 7.2.1: pg_dump -Ft -b dbname > filename
Version 7.4 pg_restore -d dbname filename

pg_restore: ERROR: literal carriage return found in data
HINT: Use "\r" to represent carriage return.
CONTEXT: COPY Aktionspartner, line 2: "1 Sparkasse
Pfullendorf-Meßkirch Bahnhofstraße 88630 Pfullendorf 07552 /
263-0 User Name 6905162..."
pg_restore: [archiver (db)] error returned by PQendcopy

i read in the mailing list, that others have the same problem. I know, that
COPY no longer supports literal carriage-returns in 7.4
So i would like to know if this problem is by design (of pg_restore), or if
it will be solved in a future release.

thanks,

Uwe

Browse pgsql-admin by date

  From Date Subject
Next Message Uwe Maiwald 2003-11-28 13:26:55 pg_restore 7.4 from 7.2.1
Previous Message Oli Sennhauser 2003-11-28 12:51:17 Experience wanted: low-cost Photo-Archive in TB range