Re: [GENERAL] Restore Data Encountered the ERROR: literal carriage return found in data Error

2010-03-05 Thread Richard Huxton
On 04/03/10 23:52, Wang, Mary Y wrote: Hi All, After a pg_dumpall, I'm trying to restore with psql -e template1 -f 21.bak/tmp/out21.bak . I'm trying to migrate to Postgres 8.3.8. Are you running pg_dumpall from version 8.3.8? I'm getting lots errors like this one: psql:21.bak:340557:

Re: [GENERAL] Restore Data Encountered the ERROR: literal carriage return found in data Error

2010-03-05 Thread Tom Lane
Richard Huxton d...@archonet.com writes: On 04/03/10 23:52, Wang, Mary Y wrote: I'm getting lots errors like this one: psql:21.bak:340557: ERROR: literal carriage return found in data HINT: Use \r to represent carriage return. I'd only expect this if an old pg_dumpall was being used.

Re: [GENERAL] Restore Data Encountered the ERROR: literal carriage return found in data Error

2010-03-05 Thread Wang, Mary Y
; pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore Data Encountered the ERROR: literal carriage return found in data Error Richard Huxton d...@archonet.com writes: On 04/03/10 23:52, Wang, Mary Y wrote: I'm getting lots errors like this one: psql:21.bak:340557: ERROR: literal

[GENERAL] Restore Data Encountered the ERROR: literal carriage return found in data Error

2010-03-04 Thread Wang, Mary Y
Hi All, After a pg_dumpall, I'm trying to restore with psql -e template1 -f 21.bak /tmp/out21.bak . I'm trying to migrate to Postgres 8.3.8. I'm getting lots errors like this one: psql:21.bak:340557: ERROR: literal carriage return found in data HINT: Use \r to represent carriage return.