| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Doug Kyle <dkyle(at)grpl(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dump error parent table oid of pg_rewrite entry oid not found |
| Date: | 2010-04-07 21:05:33 |
| Message-ID: | 22211.1270674333@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Doug Kyle <dkyle(at)grpl(dot)org> writes:
> I have this error from pg_dumpall:
> pg_dump: failed sanity check, parent table OID 27974 of pg_rewrite entry
> OID 28689 not found
> ...
> So I'm thinking I'll delete from pg_rewrite where oid=28689, but I'm not
> sure if I should do anything with pg_class or pg_depends - or other
> tables? Any advice?
It's probably sufficient to drop the pg_rewrite entry. There are likely
to be some pg_depend entries left behind but I don't think they are
going to hurt you. If you want to be sure, try reloading the database
from the dump file.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2010-04-07 21:08:42 | Re: Solid State Drives with PG |
| Previous Message | Vick Khera | 2010-04-07 20:54:23 | Re: Solid State Drives with PG |