Search Postgresql Archives

Re: Missing database entry in pg_database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux