Re: Not able to connect specific database

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: SAS <sas(dot)postgresql(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Not able to connect specific database
Date: 2023-11-08 20:31:27
Message-ID: CAJk5AtaufiyXq+OkHzJrOcyVT=_ziKLOzby5+M6bf7Yze3KjYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am using postgres 15.2 version on a openshift container platform.

We recently upgraded the openshift version. Did not have any problem in
staging and then upgraded in production also.

After which, in in cluster we r having around 10 dbs. Out of which I tried
to connect one db using \c dbname...9dbs I am able to connect. But this one
particular db, when I tried to connect , it throws an error "PANIC: could
not open critical system index 2662". That's the story..please let me know
if any additional information required.

On Wed, 8 Nov 2023, 20:05 SAS, <sas(dot)postgresql(at)gmail(dot)com> wrote:

> Le 08/11/2023 à 11:43, Rajesh Kumar a écrit :
>
> How to solve this then?
>
> On Wed, 8 Nov, 2023, 4:05 PM SAS, <sas(dot)postgresql(at)gmail(dot)com> wrote:
>
>> Le 05/11/2023 à 14:11, Kumar Rajesh a écrit :
>>
>> Hi team,
>>
>> I am not able to connect to one specific database and receiving error "
>> PANIC:could not open critical system index 2662" as attached in picture .
>> But I am able to connect other remaining database in samee instance.
>>
>> Kindly help
>>
>> I wonder if you are running your database into a container which also
>> contains your data, making data disappear when restarting the container...
>>
>> S.
>>
>
> You don't give enough information to be helped.
> --
> Dr Stéphane Schildknecht
> Contact régional PostgreSQL pour l'Europe francophone
> +33 617 11 37 42
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-11-08 21:00:48 Re: vacuuming postgresql15 issues
Previous Message Keith Fiske 2023-11-08 14:52:50 Re: Operating system upgrades on PostgreSQL nodes using streaming replication