Re: Missing database entry in pg_database

Robert Korteweg <robert ( at ) sambalbij ( dot ) nl> writes:
>> I have a problem with a database i'm maintaining. I first noticed
>> the problem because i could not make a backup of the database i got
>> the following error:

>> pg_dump: missing pg_database entry for database "xxx"

>> I verified this by selecting the pg_database. It was indeed gone.

>> I did some more diggin and noticed that on doing a describe (\d
>> <table>) of a table i could not see any or some of the columns in
>> the table, and a few tables i also could just see the correct
>> layout. It looks random.

> This sounds suspiciously like a transaction ID wraparound problem.
Yes i read about that, but i thought this was not my problem because i
vacuumed like i thought i should.

>> The database is a very active database. It is running on Postgresql
>>  7.3. The database is getting a VACUUM FULL ANALYZE every night.

> The *entire* database ... or are you just vacuuming the user tables
> and not the system catalogs?  Daily vacuuming of the catalogs should
> have prevented any such problem (unless you are managing to exceed 1
> billion transactions per day...)

VACUUM FULL ANALYZE is the exact query i do on the database every night.
I do not know if postgres will vacuum the systemtables as well with this
command. And i do not believe the database will exceed the billion
transactions a day.

I also do not see the template databases, but i do not know if this is
important.


--
"You can't reach second base, and keep your foot on first."

Groeten,
Robert