script has ended -> so, it was a piece of sql sentences, no drop at any
databases disappeared -> the db is not any more, or the relations are not
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:
> 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: 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
> 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 Nikolov||Date: 2005-07-27 12:29:35|
|Subject: Problem with the compilation and running of postgresql|
|Previous:||From: Marco Rademeyer||Date: 2005-07-27 09:49:59|
|Subject: Database disappeared|