Skip site navigation (1) Skip section navigation (2)

Re: cache lookup failed for index

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Nathan Robertson" <nathan(dot)robertson(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: cache lookup failed for index
Date: 2010-06-30 16:13:21
Message-ID: 4C2B26D10200002500032D97@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Nathan Robertson <nathan(dot)robertson(at)gmail(dot)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

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2010-06-30 16:14:23
Subject: Re: cache lookup failed for index
Previous:From: Nathan RobertsonDate: 2010-06-30 16:04:06
Subject: Re: cache lookup failed for index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group