Re: "PANIC: could not open critical system index 2662" - twice - Mailing list pgsql-general

From Andrew Gierth
Subject Re: "PANIC: could not open critical system index 2662" - twice
Date
Msg-id 87fs8bb2f7.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to "PANIC: could not open critical system index 2662" - twice  (Evgeny Morozov <postgresql3@realityexists.net>)
Responses Re: "PANIC: could not open critical system index 2662" - twice  (Evgeny Morozov <postgresql3@realityexists.net>)
List pgsql-general
>>>>> "Evgeny" == Evgeny Morozov <postgresql3@realityexists.net> writes:

 Evgeny> Indeed, I cannot get that far due to the same error. I read
 Evgeny> about ignore_system_indexes, but...

 Evgeny> # sudo -u postgres psql -w -p 5434 -c "set ignore_system_indexes=on";
 Evgeny> ERROR:  parameter "ignore_system_indexes" cannot be set after connection
 Evgeny> start

sudo -u postgres psql -w -p 5434 -d "options='-P'"

(make that -d "dbname=whatever options='-P'"  if you need to specify
some database name; or use PGOPTIONS="-P" in the environment.)

--
Andrew (irc:RhodiumToad)



pgsql-general by date:

Previous
From: Evgeny Morozov
Date:
Subject: Re: "PANIC: could not open critical system index 2662" - twice
Next
From: Magnus Hagander
Date:
Subject: Re: connecting to localhost -> ::1 client_addr ?