Re: Not able to connect specific database - Mailing list pgsql-admin

From Erik Serrano
Subject Re: Not able to connect specific database
Date
Msg-id CA+dvXXuvDi3xfOvdXuNs0nuSYkZkTVfyaKtOfFS6Cs4XOUkoww@mail.gmail.com
Whole thread Raw
In response to Re: Not able to connect specific database  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
Hola, 

Para mi tienes un problema con el sistema operativo Linux donde vive el PG , es posible que uno de tus discos no esté montado ( o se haya desmontado por alguna razón) llenado, o el clúster no esté detectando el storage donde se guardan los archivos base de PostgreSQL.

Yo consultaría si la VM tiene algún problema antes de proceguir... Y si te dicen que no lo hay , bueno... Reinicia el server .



Eso, espero te ayude
Saludos

El dom., 5 de noviembre de 2023 9:41 p. m., Rajesh Kumar <rajeshkumar.dba09@gmail.com> escribió:
We are also using patronictl crunchy data for ha and pgbackrest for automatic backup..

Should I simply stop and then start using pg_ctl command

On Mon, 6 Nov 2023, 05:53 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:
Postgres 15

On Mon, 6 Nov 2023, 03:04 Jeff Janes, <jeff.janes@gmail.com> wrote:
You have some kind of corruption.  You didn't tell us what version you are using.  For me, that file being missing just causes FATAL, not PANIC.  I don't know why it would be different for you.

If you shutdown the database and then start it back up with the -P option to 'postgres' of "-o -P" for 'pg_ctl', then you should be able to connect to the database and do a REINDEX SYSTEM.  This should fix the problem.  Then you can shut it down and start it up again without the special option.  

However, once you have some kind of corruption there is no telling how much other corruption you also have.  Why would just this one file happen to be missing?

Cheers,

Jeff

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: Re: TRIGGER on a FOREIGN Table?
Next
From: Veerendra Pulapa
Date:
Subject: Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server