Re: Suddenly all tables were gone

On 01/04/2014 10:15 AM, Moshe Jacobson wrote:
> On Fri, Jan 3, 2014 at 8:37 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com
> <mailto:adrian(dot)klaver(at)gmail(dot)com>> wrote:
>
> I know the database is gone now, still for the record it would be
> nice to know what the sequence of events where. You mentioned
> pg_dump and upgrade from 9.1 -> 9.3.
>
>
> So what was done and in what order?
>
>
> First the conversion to 9.3, then I was using pg_dump.

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?

>
> Also what database where you trying to connect to, the one in 9.1 or
> 9.3?
>
>
> 9.3. The db was fine on 9.1.

So from previous posts, if I follow correctly, the database(with tables)
was in the 9.3 cluster to begin with and then later you only had
database but with no tables in it. Or to put it another way, at some
point you could connect to the 'problem' database but could find no tables.

Is that correct?

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