Re: pg_dump problem - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: pg_dump problem
Date
Msg-id 20071115180348.GP20228@crankycanuck.ca
Whole thread Raw
In response to pg_dump problem  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
On Wed, Nov 14, 2007 at 10:32:54AM -0800, SHARMILA JOTHIRAJAH wrote:
> Hi
> I try to use pg_dump to dump my database.
> pg_dump smrs
> and it gives me an error
> pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID 670741 not found

Is there any possibility you have Slony installed?  Is this a replica?  If
so, it's a well-known problem.  You can't use pg_dump under those
circumstances.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: 8.3 vs 8.2 sql compatiblity issue
Next
From: SHARMILA JOTHIRAJAH
Date:
Subject: Re: pg_dump problem