Re: Mysterious DB reset - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Mysterious DB reset
Date
Msg-id 20140305190150.GP4759@eldon.alvh.no-ip.org
Whole thread Raw
In response to Mysterious DB reset  (Israel Brewster <israel@eraalaska.net>)
Responses Re: Mysterious DB reset  (Israel Brewster <israel@eraalaska.net>)
List 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
causethis behavior? What sort of event could cause all data to be deleted from the table, and the sequence to be reset?
Especiallywhile 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


pgsql-general by date:

Previous
From: Israel Brewster
Date:
Subject: Mysterious DB reset
Next
From: Thom Brown
Date:
Subject: Re: Mysterious DB reset