Re: pg_dump problem - Mailing list pgsql-general

From Joao Miguel Ferreira
Subject Re: pg_dump problem
Date
Msg-id 1195065716.3983.54.camel@azagthot.critical.pt
Whole thread Raw
In response to pg_dump problem  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
On Wed, 2007-11-14 at 10:32 -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
>

check out the --oids option in the manuals ("man pg_dump")... could
help ?!

and try this:

pg_dump --oids smrs

Cheers
jmf

> What causes this problem?
> Thanks
> sharmila
>
>
>
>
> ______________________________________________________________________
> Be a better sports nut! Let your teams follow you with Yahoo Mobile.
> Try it now.


pgsql-general by date:

Previous
From: SHARMILA JOTHIRAJAH
Date:
Subject: pg_dump problem
Next
From: Richard Huxton
Date:
Subject: Re: PLpgsql debugger question