Re: pg_dump problem
| От | SHARMILA JOTHIRAJAH |
|---|---|
| Тема | Re: pg_dump problem |
| Дата | |
| Msg-id | 595770.72258.qm@web31110.mail.mud.yahoo.com обсуждение исходный текст |
| Ответ на | pg_dump problem (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>) |
| Список | pgsql-general |
No...I dont have slony installed. Its not a replica
sharmila
sharmila
----- Original Message ----
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-general@postgresql.org
Sent: Thursday, November 15, 2007 1:03:48 PM
Subject: Re: [GENERAL] pg_dump problem
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-general@postgresql.org
Sent: Thursday, November 15, 2007 1:03:48 PM
Subject: Re: [GENERAL] pg_dump problem
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
В списке pgsql-general по дате отправления: