Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157" - Mailing list pgsql-admin

From Benjamin Arai, Ph.D.
Subject Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157"
Date
Msg-id AANLkTin0FAf+HsYNVkV5uab7Vjoz54sqS_2K9Rp2Q17N@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157"  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Tree view
Is the index 1531353157? To be clear, I would just run:
 
REINDEX INDEX 1531353157
 
Thanks,
Benjamin

On Tue, Sep 21, 2010 at 1:57 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
On Tue, 2010-09-21 at 13:32 -0700, Benjamin Arai, Ph.D. wrote:
> Hello,
>
> The server is still running but pg_dumps output the following error.
> What should I do?

Try reindexing the index.

Joshua D. Drake

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157"
Next
From: Tom Lane
Date:
Subject: Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157"