"Bryan Encina" <bryan.encina@valleypres.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