Re: EMERGENCY

hi,

thanks for you quick reply...

trying to create the index in stand-alone mode delivers

error: index allready exists

trying to drop the index delivers:

notice: relationBuildDesc: can't open pg_statistic_relid_att_index: No such file or diretory
notice: cannot unlink 16556/15835646

then again trying to create the index delivers:

FATAL 2: could not open /var/lib/pgsql/data/pg_clog/0FF2: no such file or directory

DEBUG: shutting down
DEBUG: system has been shut down (FYI: system messages translated from german)

this didn't quite help yet ... other ideas ?

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: "pg" <pgsql-general(at)postgresql(dot)org>
Sent: Monday, July 15, 2002 7:28 PM
Subject: Re: [GENERAL] 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026