X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9CB5D52E8D for ; Wed, 27 Jul 2005 07:13:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98294-09 for ; Wed, 27 Jul 2005 10:13:24 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.204]) by svr1.postgresql.org (Postfix) with ESMTP id 585C152E61 for ; Wed, 27 Jul 2005 07:13:21 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id c2so32116nfe for ; Wed, 27 Jul 2005 03:13:23 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=crpF04Gu3DQ/Z+peIZW4wwXRA4IweGea+XbUkQkNEWhQbQOh7pl3DnpUzGI7ef+GqpfWLLiWSELCEIO6nqYSJlbIbA/lUySen0Cd03QD+5ltaed+PBjbyvHQ5AqdLWyiqEU0/B9xkPA+X5I0vpHo6p66VQZbZLiYfOLOQMmk/6E= Received: by 10.48.144.1 with SMTP id r1mr21450nfd; Wed, 27 Jul 2005 03:13:23 -0700 (PDT) Received: by 10.48.144.16 with HTTP; Wed, 27 Jul 2005 03:13:23 -0700 (PDT) Message-ID: Date: Wed, 27 Jul 2005 11:13:23 +0100 From: Guido Barosio Reply-To: Guido Barosio To: Marco Rademeyer Subject: Re: Database disappeared Cc: pgsql-admin@postgresql.org In-Reply-To: <1122457800.19198.53.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9517_21069214.1122459203104" References: <800FF6DB85F96B488D9CD739A651C5B503881230@ucidcw.uci.cu> <20050726172703.GE14882@alvh.no-ip.org> <1122457800.19198.53.camel@localhost.localdomain> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.182 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/216 X-Sequence-Number: 18272 ------=_Part_9517_21069214.1122459203104 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline You mention: script has ended -> so, it was a piece of sql sentences, no drop at any=20 time? databases disappeared -> the db is not any more, or the relations are not= =20 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 wrote:=20 >=20 >=20 > Hi >=20 > I have a very strange problem. > I was importing about 5 gigs of data last night. >=20 > 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. >=20 > in the /var/lib/postgresql/data/base/17164/ . The data is still there. >=20 > When logged into the databases >=20 > \d gives me the following output: > 'no relations found ' >=20 > Is there any way that I can put these relations back? > Any help would be great. >=20 > Regards > Marco Rademeyer >=20 >=20 > Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page509= 3 > ? > If you don't have web access, the disclaimer can be mailed to you on=20 > request. > Disclaimer requests to be sent to it-security@pnp.co.za >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >=20 --=20 "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. ------=_Part_9517_21069214.1122459203104 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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 relat= ions 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 stra= nge problem.
I was importing about 5 gigs of data last night.

Whe= n 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 fo= llowing output:
'no relations found '

Is there any way that I can put these rela= tions 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 hav= e web access, the disclaimer can be mailed to you on request.
Disclaimer= requests to be sent to it-securit= y@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
perfo= rmance, not more" - Tom Lane.=20 ------=_Part_9517_21069214.1122459203104--