Thread: 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

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 unknown
>
> more detailed messages are attached.
>
>
> could somebody help me please fixing this problem?
>
> thanks in advance
> thomas
>

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