Thread: pg_dump error (loading 7.2.2-dump in 7.4b4)

pg_dump error (loading 7.2.2-dump in 7.4b4)

From
Andreas Joseph Krogh
Date:
-----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-----