| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Justin M Wozniak <jwozniak(at)cse(dot)nd(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Possible DB corruption |
| Date: | 2007-05-28 22:18:09 |
| Message-ID: | 20070528221809.GA65962@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Allison | 2007-05-28 22:28:09 | arrays in where |
| Previous Message | Michael Fuhr | 2007-05-28 22:14:14 | Re: Possible DB corruption |