Re: Suddenly all tables were gone - Mailing list pgsql-general

From Tom Lane
Subject Re: Suddenly all tables were gone
Date
Msg-id 8524.1388781783@sss.pgh.pa.us
Whole thread Raw
In response to Re: Suddenly all tables were gone  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-general
Moshe Jacobson <moshe@neadwerx.com> writes:
> On Fri, Jan 3, 2014 at 2:42 PM, Tom Lane <tgl@sss.pgh.pa.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


pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: Creating an index alters the results returned
Next
From: John R Pierce
Date:
Subject: Re: Suddenly all tables were gone