Re: Suddenly all tables were gone

> Yesterday I found that one of the databases in my database cluster suddenly lost all its tables.
> A \dt in psql showed nothing.

Is there any chance this could be a search_path issue? Do you have a ~/.psqlrc?

Or are you sure you're in the right database? If you are connecting as
the postgres user, are you using \c?

Sorry for the "is it plugged in?" questions, but hopefully it's
something along those lines rather than anything more complicated!

Paul

On Fri, Jan 3, 2014 at 11:20 AM, Moshe Jacobson <moshe(at)neadwerx(dot)com> wrote:
> 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

--
_________________________________
Pulchritudo splendor veritatis.