Re: pg_restore recovery from error. - Mailing list pgsql-hackers

From Chris Bowlby
Subject Re: pg_restore recovery from error.
Date
Msg-id 6.1.0.6.2.20040615200127.02464c10@mail.pgsql.com
Whole thread Raw
In response to Re: pg_restore recovery from error.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
In that table I'm pretty sure there are no other records, but I'm hoping 
there are some records for the tables stored after that particular table..

At 05:48 PM 6/15/2004, Tom Lane wrote:
>Chris Bowlby <chris@pgsql.com> writes:
> > pg_restore: restoring data for table "test_opens"
> > pg_restore: restoring data for table "test_unsubs"
> > pg_restore: [custom archiver] could not read data block -- expected 4096,
> > got 3870
> > pg_restore: *** aborted because of error
>
> >   It appears some of the data itself is not readable, which is fine, but
> > I'd like it to skip past this table and move onto the next one. Has anyone
> > got any ideas as to where I should look for that?
>
>You sure there is a next one?  This sounds more like a truncated dump file
>than anything else ...
>
>                         regards, tom lane





pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: initdb initial password
Next
From: Doug McNaught
Date:
Subject: Re: initdb initial password