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