| 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: | Whole Thread | Raw Message | 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
| 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 |