Re: Not able to connect specific database

From: Erik Serrano <eserranos(at)gmail(dot)com>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Cc: SAS <sas(dot)postgresql(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Not able to connect specific database
Date: 2023-11-09 11:47:13
Message-ID: CA+dvXXs=83QB26yE0gyg4p1t2p9x9Uh8V_kZdb1SAquxN+xq8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

La falla se presenta al conectar esa base en particular o en las 9
restantes (dijistes que tienes 10 bases)

Saludos

*Erik R. Serrano Saavedra*
*Ingeniero de Sistemas Informáticos*
* Data Base Administrator*

El mié, 8 nov 2023 a las 17:31, Rajesh Kumar (<rajeshkumar(dot)dba09(at)gmail(dot)com>)
escribió:

> 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

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-11-09 12:12:58 Re: Foreign key constraints on partition tables
Previous Message Daulat 2023-11-09 05:54:14 Foreign key constraints on partition tables