Re: cache lookup failed for index - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: cache lookup failed for index
Date
Msg-id 4C2B26D10200002500032D97@gw.wicourts.gov
Whole thread Raw
In response to Re: cache lookup failed for index  (Nathan Robertson <nathan.robertson@gmail.com>)
List pgsql-admin
Nathan Robertson <nathan.robertson@gmail.com> wrote:

> My thinking based on the documentation is I run (as postgres
> user):
> postgres -O -P -D /dbcluster/location

Looks good to me.  In fact, I hadn't remembered the -P option;
definitely a good choice here, and it should obviate the need to try
to disable the index usage using the commands I showed.

> Then I run:
> REINDEX TABLE pg_class_oid_in;

You either need to specify the INDEX keyword or a table name.
Perhaps this would be best:

REINDEX TABLE pg_class;

-Kevin

pgsql-admin by date:

Previous
From: Nathan Robertson
Date:
Subject: Re: cache lookup failed for index
Next
From: Tom Lane
Date:
Subject: Re: cache lookup failed for index