pg_dump error (loading 7.2.2-dump in 7.4b4)
От | Andreas Joseph Krogh |
---|---|
Тема | pg_dump error (loading 7.2.2-dump in 7.4b4) |
Дата | |
Msg-id | 3F854DC1.70309@officenet.no обсуждение исходный текст |
Список | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. If this isn't the right list for this type of question, please redirect me to the relevant list. I get the following error trying to restore a 7.2.2-dump-file in 7.4b4: psql:nbeweb-db-as_copy-7.2.2.dmp:2051589: invalid command \nHelena psql:nbeweb-db-as_copy-7.2.2.dmp:2051589: invalid command \N psql:nbeweb-db-as_copy-7.2.2.dmp:2051589: invalid command \N The dump is created with "pg_dump -O nbeweb > nbeweb-db-as_copy-7.2.2.dmp" This error does not occur if I dump it with "pg_dump -O -D". But restoring a dump with -D takes 6 hours(dumpfile is 1.2 GB). The line in question(2051589) is here(starting with "8\t"): COPY "logg" FROM stdin; 8 Oslo Hamburg 21. oktober 2002 Bjørn E. Moe Hansteens gate 9, 0253 Oslo 22 31 31 62 22 55 34 23 900 90 729 22 42 50 33 bjorn@nor-way.no Bjørn E. M., kjønn Mann, Nasjonalitet NO\nHelena E., kjønn Kvinne, Nasjonalitet SE\n Hotel Alte Wache 4 14.okt.2002 \N 3740 \N 1 . . . I get several errors above the mentioned error: psql:nbeweb-db-as_copy-7.2.2.dmp:2050610: ERROR: relation "on_article_searchable" does not exist psql:nbeweb-db-as_copy-7.2.2.dmp:2050614: invalid command \ psql:nbeweb-db-as_copy-7.2.2.dmp:2050647: ERROR: syntax error at or near "1358" at character 1 psql:nbeweb-db-as_copy-7.2.2.dmp:2050614: invalid command \ psql:nbeweb-db-as_copy-7.2.2.dmp:2050647: ERROR: syntax error at or near "1358" at character 1 psql:nbeweb-db-as_copy-7.2.2.dmp:2050731: ERROR: syntax error at or near ""nei"" at character 1 psql:nbeweb-db-as_copy-7.2.2.dmp:2050732: ERROR: syntax error at or near "' '" at character 1 psql:nbeweb-db-as_copy-7.2.2.dmp:2051237: invalid command \N psql:nbeweb-db-as_copy-7.2.2.dmp:2051580: invalid command \. The table on_article_searchable doesn't exist 'cause I havn't installed tsearch yet(on purpose). Is it possible that pg_dump gets confused by previous errors? AFAIK, the \. command is to end a COPY "table" from stdin; command. I cannot risk to get partially copied tables, so the only solution seems to be to restore with a dump created with the -D option. AFAIK, \n are newlines and \N ar NULLs right? Why isnt psql able to parse it as such when restoring with COPY? It seems to think those are commands (backslash-commands), and not data. Anyone care to shed some light on this? - -- Andreas Joseph Krogh <andreak@officenet.no> Managing Director, Senior Software Developer OfficeNet AS - - Writing software is more fun than working. gpg public_key: http://dev.officenet.no/~andreak/public_key.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/hU3AUopImDh2gfQRAtEoAJ9FtjI/cs+ssZhGNQcV/TG0oSuRFACfYKWc fjnJEcxHpbUhv7d6IWxDcjU= =8RZH -----END PGP SIGNATURE-----
В списке pgsql-hackers по дате отправления: