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

From Tom Lane
Subject Re: pg_restore recovery from error.
Date
Msg-id 4925.1087332523@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore recovery from error.  (Chris Bowlby <chris@pgsql.com>)
Responses Re: pg_restore recovery from error.
List pgsql-hackers
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: Chris Bowlby
Date:
Subject: Re: pg_restore recovery from error.
Next
From: Simon Riggs
Date:
Subject: PITR Recovery