Re: Database disappeared

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.