Postgres Pro
Downloads
Home   >   mailing lists

Suddenly all tables were gone - Mailing list pgsql-general

From Moshe Jacobson
Subject Suddenly all tables were gone
Date
Msg-id CAJ4CxLmaqmqr1M0WccVyFcQdWAwOseurC6UHq0LuefDS+f6tCA@mail.gmail.com
Whole thread Raw
Responses Re: Suddenly all tables were gone  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Suddenly all tables were gone  (Paul Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-general
Tree view
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.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

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

pgsql-general by date:

Previous
From: Seb
Date:
Subject: Re: bulk loading table via join of 2 large staging tables
Next
From: Kevin Grittner
Date:
Subject: Re: pg_largeobject related issue with 9.2