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 EC98152E61 for ; Wed, 27 Jul 2005 06:54:15 -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 96813-09 for ; Wed, 27 Jul 2005 09:54:06 +0000 (GMT) Received: from trendinterscan.pnp.co.za (unknown [196.7.24.196]) by svr1.postgresql.org (Postfix) with ESMTP id 300D952E50 for ; Wed, 27 Jul 2005 06:54:03 -0300 (ADT) Received: by pnp.co.za (8.9.3+Sun/8.9.3) with ESMTP id LAA27281for ; Wed, 27 Jul 2005 11:54:00 +0200 (SAST) Received: from 164.101.15.103 (unknown [164.101.15.103])by scorenet.score.pnp.co.za (Postfix) with ESMTP id 85D88FF7for ; Wed, 27 Jul 2005 11:49:25 +0200 (SAST) Subject: Database disappeared From: Marco Rademeyer To: pgsql-admin@postgresql.org In-Reply-To: <20050726172703.GE14882@alvh.no-ip.org> References: <800FF6DB85F96B488D9CD739A651C5B503881230@ucidcw.uci.cu> <20050726172703.GE14882@alvh.no-ip.org> Content-Type: text/plain Date: Wed, 27 Jul 2005 11:49:59 +0200 Message-Id: <1122457800.19198.53.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-imss-version: 2.028 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:4 C:4 M:4 S:3 R:4 (1.0000 1.0000) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.4 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200507/215 X-Sequence-Number: 18271 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