Re: single user mode -P option is ignored - Mailing list pgsql-hackers

From Tom Lane
Subject Re: single user mode -P option is ignored
Date
Msg-id 31792.1545242490@sss.pgh.pa.us
Whole thread Raw
In response to Re: single user mode -P option is ignored  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: single user mode -P option is ignored
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> st 19. 12. 2018 v 17:59 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
>> So either this is something we fixed since 9.5.5, or your summary
>> of the problem is missing many critical details.

> I got different error message "could not open critical system index". I
> checked files, and related files was there.

Hmm ... looking at the relcache code, it appears that could only happen
if the pg_class entry for that index couldn't be found.  Which probably
means you've suffered catastrophic damage to pg_class --- there's no
good reason to assume that only that one row has been clobbered.
Reindexing isn't going to get you out of that :-(

            regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: single user mode -P option is ignored
Next
From: Massimo Fidanza
Date:
Subject: Re: GraalVM