Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157"

["Benjamin Arai, Ph.D." <benjamin@xxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxxx> 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