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