Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id EAC521337B48 for ; Tue, 21 Sep 2010 18:30:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 86380-01 for ; Tue, 21 Sep 2010 21:30:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id A10621337B4A for ; Tue, 21 Sep 2010 18:30:06 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o8LLU5ZB009736; Tue, 21 Sep 2010 17:30:05 -0400 (EDT) To: "Benjamin Arai, Ph.D." cc: pgsql-admin Subject: Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157" In-reply-to: References: Comments: In-reply-to "Benjamin Arai, Ph.D." message dated "Tue, 21 Sep 2010 13:32:40 -0700" Date: Tue, 21 Sep 2010 17:30:05 -0400 Message-ID: <9735.1285104605@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/129 X-Sequence-Number: 35673 "Benjamin Arai, Ph.D." writes: > The server is still running but pg_dumps output the following error. What > should I do? Try reindexing pg_index in whichever database is giving trouble. Depending on what PG version you are using (which is something that should ALWAYS be mentioned in any kind of trouble report), you might need to stop the server so you can do this in a standalone backend. Read the relevant version of the REINDEX reference page for more info. regards, tom lane