Skip site navigation (1) Skip section navigation (2)

Re: Problem accessing database on nodes of a cluster

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kashif Riaz <kriaz(at)cs(dot)uno(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem accessing database on nodes of a cluster
Date: 2004-11-27 18:31:09
Message-ID: 27142.1101580269@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Kashif Riaz <kriaz(at)cs(dot)uno(dot)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

In response to

pgsql-admin by date

Next:From: EXT-Ross, NormanDate: 2004-11-29 18:01:01
Subject: Create and execute a Pass through Query
Previous:From: Bruce MomjianDate: 2004-11-27 04:15:30
Subject: Re: high (or at least improved) availability and failover

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group