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

Поиск
Список
Период
Сортировка
От Wang, Mary Y
Тема Restore Data Encountered the ERROR: literal carriage return found in data Error
Дата
Msg-id FA20D4C4FEBFD148B1C0CB09913825FC01EBE7D0CF@XCH-SW-06V.sw.nos.boeing.com
обсуждение исходный текст
Ответы Re: Restore Data Encountered the ERROR: literal carriage return found in data Error  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
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
Postgres8.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."
After doing some research, one person posted here :
http://forums.devshed.com/postgresql-help-21/restoring-data-from-pg-7-1-3-7-4-release-99865.htmland this person said 
"sed 's/^M/\\r/' alldump.sql > alldump2.sql
where ^M is entered by pressing Ctrl+V then Enter. "

I'm confused why "Ctrl+V"?  I thought that is a paste function key.


Mary




В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Auto VACUUM
Следующее
От: Mridula Mahadevan
Дата:
Сообщение: Foreign key behavior different in a function and outside