Database disappeared - Mailing list pgsql-admin

From Marco Rademeyer
Subject Database disappeared
Date
Msg-id 1122457800.19198.53.camel@localhost.localdomain
Whole thread Raw
In response to Re: Hola  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Database disappeared  (Guido Barosio <gbarosio@gmail.com>)
Re: Database disappeared  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi

I have a very strange problem.
I was importing about 5 gigs of data last night.

When I got in this morning the script had completed. But my database has
disappeared. I login to the databases , but all the tables are gone.

in the /var/lib/postgresql/data/base/17164/ . The data is still there.

When logged into the databases

\d  gives me the following output:
 'no relations found '

Is there any way that I can put these relations back?
Any help would be great.

Regards
Marco Rademeyer


Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093?
If you don't have web access, the disclaimer can be mailed to you on request.
Disclaimer requests to be sent to it-security@pnp.co.za


pgsql-admin by date:

Previous
From: "Luca Stancapiano"
Date:
Subject: error on launching postgres in ssl mode
Next
From: Guido Barosio
Date:
Subject: Re: Database disappeared