| From: | "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in> |
|---|---|
| To: | Chris Bowlby <chris(at)pgsql(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_restore recovery from error. |
| Date: | 2004-06-15 17:46:49 |
| Message-ID: | 40CF3609.4070106@sancharnet.in |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-06-15 18:29:32 | Re: OWNER TO on all objects |
| Previous Message | Josh Berkus | 2004-06-15 17:43:20 | Re: #postgresql report |