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:26:55
Message-ID: 5.2.1.1.0.20031128142554.00a7add0@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 Marek Florianczyk 2003-11-28 13:45:19 Re: Experience wanted: low-cost Photo-Archive in TB range
Previous Message Uwe Maiwald 2003-11-28 13:03:24 pg_restore 7.4 from 7.2.1