| From: | Joao Miguel Ferreira <joao(dot)mc(dot)ferreira(at)criticalsoftware(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump problem |
| Date: | 2007-11-14 18:41:56 |
| Message-ID: | 1195065716.3983.54.camel@azagthot.critical.pt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-11-14 18:44:09 | Re: PITR and warm standby setup questions |
| Previous Message | Richard Huxton | 2007-11-14 18:40:26 | Re: PLpgsql debugger question |