Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 492E6632CFA for ; Wed, 4 Feb 2009 20:03:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77284-07-2 for ; Wed, 4 Feb 2009 20:03:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f21.google.com (mail-gx0-f21.google.com [209.85.217.21]) by mail.postgresql.org (Postfix) with ESMTP id 1CA75632CF3 for ; Wed, 4 Feb 2009 20:03:49 -0400 (AST) Received: by gxk14 with SMTP id 14so3030114gxk.19 for ; Wed, 04 Feb 2009 16:03:48 -0800 (PST) MIME-Version: 1.0 Received: by 10.151.157.1 with SMTP id j1mr93389ybo.83.1233792228534; Wed, 04 Feb 2009 16:03:48 -0800 (PST) In-Reply-To: <6AC9217D-1019-4965-A76E-DE983638410B@indiana.edu> References: <6AC9217D-1019-4965-A76E-DE983638410B@indiana.edu> Date: Wed, 4 Feb 2009 19:03:48 -0500 Message-ID: <16b031c0902041603w61065a46y1ba6977b0a427049@mail.gmail.com> Subject: Re: Failed sanity check? From: Lee Azzarello To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/39 X-Sequence-Number: 31260 Can you perform queries against tables in that database? You may have to poke around in the systems tables for the object ids in question. -lee On Wed, Feb 4, 2009 at 2:32 PM, Carol Walter wrote: > Hello, > > I'm getting this message when I try to back up one of my databases. Is > there something I can do about this? > > bash-3.00# pg_dump -U postgres citesrch > /pgdump/citesrch_bk.sql > pg_dump: failed sanity check, parent table OID 131956046 of pg_rewrite entry > OID 131956048 not found > > Thanks, > > Carol > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >