Re: pg_restore recovery from error.

Dear Chris ,

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


Make a plain text  file out of  your  archive and then edit apropriately 
for desired results

I dont remember the way it could be done but something live

pg_restore -U <BOGUS>  >> my_database.sql
cat my_database.sql

Drawbacks :
1. Large database would be headache
2. Blobs would not be restored


-- 
Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Yahoo  IM: mailforvishal[ a t ]yahoo.com