pg_restore recovery from error. - Mailing list pgsql-hackers

From Chris Bowlby
Subject pg_restore recovery from error.
Date
Msg-id 6.1.0.6.2.20040615135106.026093e0@pop.accesswave.ca
Whole thread Raw
Responses Re: pg_restore recovery from error.
Re: pg_restore recovery from error.
Re: pg_restore recovery from error.
List pgsql-hackers
Hi All,
 I've been attempting to recover some data from a data file that was 
dumped and compressed using pg_dump. I've noticed that the pg_restore 
application was supposed to have some work put into place to help it 
continue of it ran into an error, but I've run into an issue here it is not 
continuing past an error that I'm getting:

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?




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: #postgresql report
Next
From: Peter Eisentraut
Date:
Subject: Re: #postgresql report