contents of pg_database vanished..

From: Kari Lavikka <tuner(at)bdb(dot)fi>
To: pgsql-general(at)postgresql(dot)org
Subject: contents of pg_database vanished..
Date: 2004-06-07 15:10:43
Message-ID: Pine.HPX.4.51.0406071809520.12357@purple.bdb.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm having some problems with pg_database -system table. It lost all of
it's contents while database was running. It's actually still running but
I don't know what to do because I'm not sure if it will start up at all
after shutdown.

I noticed the problem while trying to use pg_dump:
tuner(at)xyzzy:~$ /usr/local/pgsql/bin/pg_dump -Ugalleria galleria
pg_dump: missing pg_database entry for database "galleria"

I could probably insert the missing row to pg_database but there are some
columns I'm not sure about. What are datlastsysoid, datvacuumxid and
datfrozenxid?

Btw, pg version is 7.4.1

Thanks..

|\__/|
( oo ) Kari Lavikka - tuner(at)bdb(dot)fi - (050) 380 3808
__ooO( )Ooo_______ _____ ___ _ _ _ _ _ _ _
""

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Campano, Troy 2004-06-07 15:27:15 Re: Backup and Restore of PostgreSQL
Previous Message Maarten Boekhold 2004-06-07 15:04:03 Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?