Re: EMERGENCY - Mailing list pgsql-general

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@topconcepts.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@candle.pha.pa.us>
To: "Henrik Steffen" <steffen@city-map.de>
Cc: "pg" <pgsql-general@postgresql.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@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