Re: Unable to Connect to DB Instance - Mailing list pgsql-general

From Tom Lane
Subject Re: Unable to Connect to DB Instance
Date
Msg-id 66417.1530719397@sss.pgh.pa.us
Whole thread Raw
In response to Unable to Connect to DB Instance  (Boblitz John <john.boblitz@bertschi.com>)
Responses RE: Unable to Connect to DB Instance  (Boblitz John <john.boblitz@bertschi.com>)
List pgsql-general
Boblitz John <john.boblitz@bertschi.com> writes:
> 2.       Users reported messages similar to "could not open file "global/11801": No such file or directory"

I'd try "select relname from pg_class where pg_relation_filenode(oid) =
11801" to see if you can identify the problematic relation that way.

If you're lucky, this is just loss of some system catalog index in which
case reindexing will fix it.  The fact that you're able to get through
connecting, and the errors only show up with queries, is somewhat
promising given that the problem looks like it's related to pg_authid
or pg_db_role_setting.

            regards, tom lane


pgsql-general by date:

Previous
From: hmidi slim
Date:
Subject: Re: Return select statement with sql case statement
Next
From: Adrian Klaver
Date:
Subject: Re: Unable to Connect to DB Instance