Re: Mysterious DB reset

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Israel Brewster <israel(at)eraalaska(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Mysterious DB reset
Date: 2014-03-05 19:01:50
Message-ID: 20140305190150.GP4759@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Israel Brewster wrote:

> So my question is, aside from someone going in and mucking about in the wee hours of the morning, what could possibly cause this behavior? What sort of event could cause all data to be deleted from the table, and the sequence to be reset? Especially while there is an active connection? Thanks for any ideas, however wild or off the wall :-)

Is this running off a NFS mount or something? I'm wondering about the
filesystem getting unmounted and an empty copy of the database being in
the mountpoint.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2014-03-05 19:01:54 Re: Mysterious DB reset
Previous Message Israel Brewster 2014-03-05 18:22:08 Mysterious DB reset