Database disappeared

From: Marco Rademeyer <mrademeyer(at)pnp(dot)co(dot)za>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database disappeared
Date: 2005-07-27 09:49:59
Message-ID: 1122457800.19198.53.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pnp(dot)co(dot)za

In response to

  • Re: Hola at 2005-07-26 17:27:03 from Alvaro Herrera

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2005-07-27 10:13:23 Re: Database disappeared
Previous Message Luca Stancapiano 2005-07-27 08:26:47 error on launching postgres in ssl mode