Re: Suddenly all tables were gone

On 01/04/2014 12:58 PM, Moshe Jacobson wrote:

Ccing the list.
>
> On Sat, Jan 4, 2014 at 2:08 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com
> <mailto:adrian(dot)klaver(at)gmail(dot)com>> wrote:
>
>
> So we are looking at a fresh 9.3 cluster.
> So you created an 9.3 instance and then used pg_dump to transfer the
> data from the 9.1 instance to the 9.3 instance?
>
>
> No. I used pg_upgrade on the 9.1 cluster. The pg_dump was unrelated to
> the upgrade.

So where does the pg_dump fit in?

Or more to the point why do you think it could be a possible cause of
the problem?

>
> at some point you could connect to the 'problem' database but could
> find no tables.
>
>
> Correct.

So anything of note happen in that interval?

Do the logs over that time period show anything?

>
>
> 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

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com