Re: Possible DB corruption

On Fri, May 25, 2007 at 04:47:52PM -0400, Justin M Wozniak wrote:
>     We noticed that some records were mysteriously disappearing from
> our DB.  I went in with psql and found that the \dt command no longer
> works, providing the output below.  Is this a sure sign of DB corruption?
> Running psql (PostgreSQL) 7.4.8 on Linux 2.4.27.

You might be suffering from transaction ID wraparound.  Are you
vacuuming regularly?

http://www.postgresql.org/docs/7.4/interactive/maintenance.html#VACUUM-FOR-WRAPAROUND

"...every table in the database must be vacuumed at least once every
billion transactions."

--
Michael Fuhr