Search Postgresql Archives

Re: Suddenly all tables were gone

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 01/04/2014 10:15 AM, Moshe Jacobson wrote:
On Fri, Jan 3, 2014 at 8:37 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxx>> 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.klaver@xxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux