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

Database 'xxxx', OID yyyyy, has disappeared from pg_database

From: Michael Glenn <mike(at)mglenn(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database 'xxxx', OID yyyyy, has disappeared from pg_database
Date: 2002-04-24 22:24:52
Message-ID: 3CC730B4.3090408@mglenn.com (view raw or flat)
Thread:
Lists: pgsql-admin
I receive the following error when trying to connect to ALL postgres 
databases on my system.

Database 'xxxx', OID yyyyy, has disappeared from pg_database

The various archives have other users that had this problem and the 
solution is to vacuum the pg_database, however;

bash$ vacuumdb pg_database
psql: FATAL 1:  Database "pg_database" does not exist in the system catalog.
vacuumdb: vacuum failed

I also cannot connect to any database precluding me from running vacuum 
pg_database from the psql command line. I cannot create a database and 
attempt this as,

bash$ createdb tester
psql: FATAL 1:  Database 'template1', OID 17216, has disappeared from 
pg_database
createdb: database creation failed

Any suggestions?

RedHat
Linux Kernel 2.2.14-5
PostgreSQL 7.0.0 - yeah, I know I should have upgraded. SOL?

Thanks in advance.

-- 
Michael Glenn
http://www.mglenn.com
416.544.9904




Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2002-04-24 22:52:37
Subject: Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database
Previous:From: Dan LangilleDate: 2002-04-24 16:47:12
Subject: Re: is it a bug?

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