Suddenly all tables were gone

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Suddenly all tables were gone
Date: 2014-01-03 19:20:28
Message-ID: CAJ4CxLmaqmqr1M0WccVyFcQdWAwOseurC6UHq0LuefDS+f6tCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yesterday I found that one of the databases in my database cluster suddenly
lost all its tables. A \dt in psql showed nothing. I'm not sure how or when
it happened, but it was either due to an upgrade of postgres from 9.1 to
9.3 or else something going wrong with pg_dump.

Has anyone had this happen before?

Thanks.

Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc. <http://www.neadwerx.com>
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2014-01-03 19:24:51 Re: pg_largeobject related issue with 9.2
Previous Message Seb 2014-01-03 16:31:11 Re: bulk loading table via join of 2 large staging tables