Thomas Chille <thomas(dot)chille(at)gmail(dot)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