From: | John Gray <jgray(at)azuli(dot)co(dot)uk> |
---|---|
To: | igor(at)carcass(dot)ath(dot)cx |
Subject: | Re: can't start postgresql |
Date: | 2006-11-14 23:41:39 |
Message-ID: | pan.2006.11.14.23.41.29.744779@azuli.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote:
>> I'd think starting a standalone backend and issuing a "reindex database"
>> should be enough to get him started. Now, the problem is figuring _how_
>> the index got in that state; or even _what_ index is the problematic
>> one. (I think it would be possible to find out by setting the
>> "log_error_verbosity" parameter to "verbose").
>
> The problem is, it won't start even in the standalone mode. It prints the same
> error message and dies. I was trying to start it connected to my main db,
> template0, template1 and postgres, no change. The index corruption (assuming
> this IS an index corruption) must've happened with system table(s). Is there
> any way to diagose that ? Maybe reindex a specific table without starting
> postmaster, or remove certain index files physically (e.g. for pg_class,
> etc) ?
I think you want to use -P to ignore the indexes on startup:
postgres -D /usr/local/pgsql/data -P my_database
Does that help - then you might get the chance to do a REINDEX?
Regards
John
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2006-11-15 00:25:19 | RE : Re: database design ... |
Previous Message | Martijn van Oosterhout | 2006-11-14 23:23:58 | Re: PG_MODULE_MAGIC check in 8.2 |