Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1puqxs-0004OT-ST for pgsql-general@arkaria.postgresql.org; Fri, 05 May 2023 08:38:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1puqxr-0004HO-RX for pgsql-general@arkaria.postgresql.org; Fri, 05 May 2023 08:38:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1puqxr-0004HF-H3 for pgsql-general@lists.postgresql.org; Fri, 05 May 2023 08:38:55 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1puqxn-000hdC-U9 for pgsql-general@postgresql.org; Fri, 05 May 2023 08:38:54 +0000 Received: from [192.168.127.4] (port=22598 helo=erlenstar.riddles.org.uk) by lungold.riddles.org.uk with esmtp (Exim 4.92.3 (FreeBSD)) (envelope-from ) id 1puqxk-000Dyl-UQ; Fri, 05 May 2023 08:38:48 +0000 Received: from localhost ([127.0.0.1]:40906 helo=erlenstar.riddles.org.uk) by erlenstar.riddles.org.uk with esmtp (Exim 4.94 (FreeBSD)) (envelope-from ) id 1puqxk-000Cps-EU; Fri, 05 May 2023 08:38:48 +0000 From: Andrew Gierth To: Evgeny Morozov Cc: Thomas Munro , PostgreSQL General Subject: Re: "PANIC: could not open critical system index 2662" - twice In-Reply-To: <01020187eae42315-1cc83aed-2b4f-4c9e-ae36-ee82778f7154-000000@eu-west-1.amazonses.com> (Evgeny Morozov's message of "Fri, 5 May 2023 07:50:32 +0000") Message-ID: <87fs8bb2f7.fsf@news-spur.riddles.org.uk> References: <01020187577238cf-da8c0f4a-3ab9-445a-8c74-31ef51439f30-000000@eu-west-1.amazonses.com> <010201877966fc0d-e09f5a0b-e846-417b-b30a-b8d57ac61fa3-000000@eu-west-1.amazonses.com> <010201877c0423c8-0a35b03c-d274-4857-ba99-ff7ea51d676b-000000@eu-west-1.amazonses.com> <8486f71f9c11e98af787e15e2d2ed0ecfdbf6ee7.camel@cybertec.at> <010201877eb3c125-d9aff979-cad6-407b-8b4e-012487666088-000000@eu-west-1.amazonses.com> <01020187e773e031-eecea370-714f-4858-82e5-ed1c9091eb6f-000000@eu-west-1.amazonses.com> <01020187e7f5a96c-9bd4497c-abff-4c91-8a3f-e751a1f7d4b4-000000@eu-west-1.amazonses.com> <01020187eae42315-1cc83aed-2b4f-4c9e-ae36-ee82778f7154-000000@eu-west-1.amazonses.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (berkeley-unix) Date: Fri, 05 May 2023 09:38:48 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >>>>> "Evgeny" =3D=3D Evgeny Morozov 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= =3Don"; Evgeny> ERROR: =C2=A0parameter "ignore_system_indexes" cannot be set after= connection Evgeny> start sudo -u postgres psql -w -p 5434 -d "options=3D'-P'" (make that -d "dbname=3Dwhatever options=3D'-P'" if you need to specify some database name; or use PGOPTIONS=3D"-P" in the environment.) --=20 Andrew (irc:RhodiumToad)