Re: Not able to connect specific database

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.postgresql@gmail.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.postgresql@gmail.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