
> Any ideas on why this error would occur after dropping an existing
> database and than re-creating it (createdb)?  The only work around so far
> is to completely destroy the postgres instance and start over.  
> 
> It appears that the pg_database may be getting currupted.
> 
> Sandy Barnes
> Honeywell
> Business & General Aviation Engineering
> One Technology Center
> 23500 West 105th Street
> Olathe, KS.     66061
> tel         913.712.2027
> fax        913.712.1347
> email    sandy.barnes@honeywell.com
> 

Wed, 3 Jan 2001 13:23:57 -0700 
"Barnes, Sandy (Sandra)" <Sandy.Barnes@Honeywell.com>
V7.0 Error:  OID ##### no longer exists in pg_databas
	e
"Barnes, Sandy (Sandra)" <Sandy.Barnes@Honeywell.com> writes:
>> Any ideas on why this error would occur after dropping an existing
>> database and than re-creating it (createdb)?

I assume what you're really talking about is
	Database 'xxx', OID nnn, has disappeared from pg_database
?

It's theoretically possible for that to happen if, say, a CREATE
DATABASE or DROP DATABASE failed and was rolled back part way through.
I've never heard of it happening in normal usage, though.  If you
have a reproducible way of creating this situation I'd like to know
what it is.

>> The only work around so far
>> is to completely destroy the postgres instance and start over.

Vacuuming pg_database should fix it.  The problem is that backend
startup is seizing on a dead pg_database tuple to tell it the OID
of the target database; vacuum out the dead tuples and you'll be OK.

			regards, tom lane

PS: Memo to folks reporting problems: PLEASE quote any error message
you may be getting EXACTLY.  It's a lot easier to look at the related
code if we can just grep for the message...

Wed, 03 Jan 2001 15:56:23 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: V7.0 Error: OID ##### no longer exists in pg_databas e 
I think this was fixed today.

> 
> > Any ideas on why this error would occur after dropping an existing
> > database and than re-creating it (createdb)?  The only work around so far
> > is to completely destroy the postgres instance and start over.  
> > 
> > It appears that the pg_database may be getting currupted.
> > 
> > Sandy Barnes
> > Honeywell
> > Business & General Aviation Engineering
> > One Technology Center
> > 23500 West 105th Street
> > Olathe, KS.     66061
> > tel         913.712.2027
> > fax        913.712.1347
> > email    sandy.barnes@honeywell.com
> > 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 9 Jan 2001 00:47:34 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re:  V7.0 Error:  OID ##### no longer exists in pg_databas
 e