Re: Not able to connect specific database

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Kumar Rajesh <kr97061(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Not able to connect specific database
Date: 2023-11-05 21:34:21
Message-ID: CAMkU=1zZdnNq5hcG02AMspGVb+c=jG-1gYOi0zE2mwjETPax1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2023-11-06 00:23:50 Re: Not able to connect specific database
Previous Message Jeff Janes 2023-11-05 16:54:12 Re: Error