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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-24 22:52:37 | Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database |
Previous Message | Dan Langille | 2002-04-24 16:47:12 | Re: is it a bug? |