Re: Possible DB corruption

On Mon, May 28, 2007 at 04:14:14PM -0600, Michael Fuhr wrote:
> 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.

Another possibility: has search_path changed?  You said that \dt
shows nothing but you can still query the tables -- do you use
schema-qualified table names in those queries?

--
Michael Fuhr