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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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