Re:

"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