| 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: | Whole Thread | Raw Message | 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_______ _____ ___ _ _ _ _ _ _ _
""
| 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? |