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 12:58 PM, Moshe Jacobson wrote:

Ccing the list.

On Sat, Jan 4, 2014 at 2:08 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxx>> 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.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