Re: Suddenly all tables were gone

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Suddenly all tables were gone
Дата
Msg-id 8524.1388781783@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Suddenly all tables were gone  (Moshe Jacobson <moshe@neadwerx.com>)
Список 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 по дате отправления:

Предыдущее
От: Igor Neyman
Дата:
Сообщение: Re: Creating an index alters the results returned
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Suddenly all tables were gone