Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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.

Marco Rademeyer 

Read our disclaimer at: 
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group