Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem accessing database on nodes of a cluster - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problem accessing database on nodes of a cluster
Date
Msg-id 27142.1101580269@sss.pgh.pa.us
Whole thread Raw
In response to Problem accessing database on nodes of a cluster  (Kashif Riaz <kriaz@cs.uno.edu>)
List pgsql-admin
Tree view 
Kashif Riaz <kriaz@cs.uno.edu> writes:
> psql: FATAL:  database "db001", OID 1198223, has disappeared from pg_database

Hmm, did you drop and recreate database db001?  There are some scenarios
where incoming backends can get confused in such scenarios.  Try
"VACUUM pg_database; CHECKPOINT".

            regards, tom lane

pgsql-admin by date:

Previous
From: Kashif Riaz
Date:
Subject: Problem accessing database on nodes of a cluster
Next
From: "EXT-Ross, Norman"
Date:
Subject: Create and execute a Pass through Query