| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Suddenly all tables were gone |
| Date: | 2014-01-03 20:43:03 |
| Message-ID: | 8524.1388781783@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Moshe Jacobson <moshe(at)neadwerx(dot)com> writes:
> On Fri, Jan 3, 2014 at 2:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Could we see the output from pg_controldata?
> Here you go. The problem database has already been dropped and re-created,
Then the evidence is pretty much gone I'm afraid :-(
> Latest checkpoint's NextXID: 0/32280314
Hm, this cluster is nowhere near old enough for wraparound to be an
issue. No idea now what happened to you.
If it happens again, please rename the broken DB out of the way rather
than summarily dropping it. We'll not have much chance of identifying
the cause without some forensic work.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2014-01-03 20:59:17 | Re: Suddenly all tables were gone |
| Previous Message | Igor Neyman | 2014-01-03 20:42:03 | Re: Creating an index alters the results returned |