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

From Evgeny Morozov
Subject Re: "PANIC: could not open critical system index 2662" - twice
Date
Msg-id 01020187eb2ebb95-bce9827e-141b-4f45-865c-3edc61e3d830-000000@eu-west-1.amazonses.com
Whole thread Raw
In response to Re: "PANIC: could not open critical system index 2662" - twice  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-general
On 5/05/2023 10:38 am, Andrew Gierth wrote:
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.)

Thanks, good to know! Unfortunately that also fails:

# sudo -u postgres psql -w -p 5434 -d "dbname=test_behavior_638186279733138190 options='-P'"
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5434" failed: FATAL:  could not open relation with OID 2964

(PG server log contains the same error message and no further details.)

select 2964::regclass returns "pg_db_role_setting" FWIW.

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: connecting to localhost -> ::1 client_addr ?
Next
From: jian he
Date:
Subject: customized function to Reconstructs the creating command for a role.