Thomas Chille <thomas.chille@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
