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@pnp.co.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@pnp.co.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.