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

Re: Database disappeared

From: Guido Barosio <gbarosio(at)gmail(dot)com>
To: Marco Rademeyer <mrademeyer(at)pnp(dot)co(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database disappeared
Date: 2005-07-27 10:13:23
Message-ID: f7f6b4c7050727031379a1d9be@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
You mention:
 script has ended -> so, it was a piece of sql sentences, no drop at any 
time?
 databases disappeared -> the db is not any more, or the relations are not 
more there?
 Could this script create a schema and moved everything on this schema?
 try postgresql-shell # \dn
 That should list your schemas.
 On 7/27/05, Marco Rademeyer <mrademeyer(at)pnp(dot)co(dot)za> wrote: 
> 
> 
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 



-- 
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

In response to

pgsql-admin by date

Next:From: Martin NikolovDate: 2005-07-27 12:29:35
Subject: Problem with the compilation and running of postgresql
Previous:From: Marco RademeyerDate: 2005-07-27 09:49:59
Subject: Database disappeared

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