7.3.4 dump/restore error
Hi!
I dumped from a 7.3.4 server on debian with kernel 2.6 using this command:
pg_dump -F c -Z 9 -f backoffice.dmp.c backoffice
I tried to restore on a similiar system using:
pg_restore -vd backoffice backoffice.dmp.c
and stepped into an error:
ERROR: copy: line 270892, Missing data for column "id_tax"
..
FATAL: Socket command type 3 unknown
more detailed messages are attached.
could somebody help me please fixing this problem?
thanks in advance
thomas
i forgot to attach the error messages. but now!
t
Show quoted text
On 7/16/05, Thomas Chille <thomas.chille@gmail.com> wrote:
Hi!
I dumped from a 7.3.4 server on debian with kernel 2.6 using this command:
pg_dump -F c -Z 9 -f backoffice.dmp.c backoffice
I tried to restore on a similiar system using:
pg_restore -vd backoffice backoffice.dmp.c
and stepped into an error:
ERROR: copy: line 270892, Missing data for column "id_tax"
..
FATAL: Socket command type 3 unknownmore detailed messages are attached.
could somebody help me please fixing this problem?
thanks in advance
thomas
Attachments:
error.txttext/plain; name=error.txtDownload
Thomas Chille <thomas.chille@gmail.com> writes:
I dumped from a 7.3.4 server on debian with kernel 2.6 using this command:
pg_dump -F c -Z 9 -f backoffice.dmp.c backoffice
I tried to restore on a similiar system using:
pg_restore -vd backoffice backoffice.dmp.c
and stepped into an error:
ERROR: copy: line 270892, Missing data for column "id_tax"
Try asking pg_restore to dump to a text file (maybe dump just this one
table) and look at the data to see if you can tell what happened to it.
Note the line number is within the copy data, ie, the first data line
after the COPY command is line 1.
regards, tom lane