Re: EMERGENCY

Henrik Steffen wrote:
>
> Hello Tom, anyone, please help me urgently:
>
> select * from ANY_TABLE_IN_MY_DB;
>
> ALWAYS GIVES:
>
> ERROR: cannot open pg_statistic_relid_att_index: No such file or directory
>
> this is happening in my LIVE System!! how can I repair this quickly ?
>
> or is only an initb possible?
>
> thanks in advance
>
> ps.
> it's certainly still due to the memory problem. I ordered a completely new
> server which will be up and running in 2 or 3 hours hopefully. but what can I do
> now??

Seems you lost your optimizer statistics.  Not sure how to fix that.
There is a reindex command, but I don't know if it will recreate an
index that doesn't even exist anymore and creating system indexes can be
tricky.  I think the only way to do that is to start a standalone
backend with the -O flag and recreate the index.  The description I have
for the index is:

Indexes: pg_statistic_relid_att_index unique btree (starelid, staattnum)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026