| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | bryan(dot)encina(at)valleypres(dot)org |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2003-11-20 21:16:53 |
| Message-ID: | 6866.1069363013@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"Bryan Encina" <bryan(dot)encina(at)valleypres(dot)org> writes:
> Upgraded from 7.1.3 to 7.4 (been waiting on this for a while thanks for all
> the hard work guys) and am having problems restoring from a pg_dumpall.
> psql:alldump.sql:12724: ERROR: literal carriage return found in data
> HINT: Use "\r" to represent carriage return.
Hm, that's a bit of a large version jump :-(. You might be able to make
it work by using the 7.4 pg_dump (which I'd recommend anyway) and
selecting -d or -D mode ... but that would be a lot slower to restore
than the COPY-based dump.
The most useful approach is probably just to run a quick sed script over
the dump file to fix the embedded carriage returns.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryan Encina | 2003-11-20 21:44:36 | Re: |
| Previous Message | Bryan Encina | 2003-11-20 20:43:44 |