Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

From: Greg Johnson <greg(dot)johnson(at)interprose(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin
Date: 2011-07-21 20:29:42
Message-ID: CAD6QHKRrVui3yB5hye+HALG2QYWtRoQj5xzvqG1a3uKju6bDdg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Interesting.. I was able to pg_restore -f to a file... and then psql -f the
resulting file. and it loaded just fine.. the down side to this method is I
cannot use the parallel load function (and the extra time). but I am glad
that I got the data loaded. Let me know if there is any other info I get
you.

On Thu, Jul 21, 2011 at 12:58 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Greg Johnson <greg(dot)johnson(at)interprose(dot)com> writes:
> > On Thu, Jul 21, 2011 at 11:44 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> This looks like pg_restore is terminating unexpectedly. What do you see
> >> on the client end of it?
>
> > pg_restore: [custom archiver] could not read from input file: end of file
>
> Well, that suggests you have a truncated or otherwise corrupted pg_dump
> archive file. Do you get a similar failure if you just do "pg_restore
> -l" on the archive file? Is the pg_dump run reporting any signs of
> distress?
>
> regards, tom lane
>

--
----------------------------------------------------------------
Greg Johnson
The InterProse Corporation
Software Developer
Phone: (360) 604-3531 x225
Fax: (360) 604-3579

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-07-21 21:10:05 Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin
Previous Message Tom Lane 2011-07-21 19:58:29 Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin