X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0B15A9DC855 for ; Tue, 21 Feb 2006 05:22:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34258-01 for ; Tue, 21 Feb 2006 05:22:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by postgresql.org (Postfix) with ESMTP id 5034A9DC811 for ; Tue, 21 Feb 2006 05:22:03 -0400 (AST) Received: obelix.askesis.nl 172.31.0.1 from 172.31.1.8 172.31.1.8 via HTTP with MS-WebStorage 6.0.6249 Received: from Panoramix.Askesis.nl by obelix.askesis.nl; 21 Feb 2006 10:22:03 +0100 Subject: Disk crash problems: postgres database not functioning anymore From: Joost Kraaijeveld To: Pgsql-Admin Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Tue, 21 Feb 2006 10:21:31 +0100 Message-Id: <1140513691.9493.5.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.079 required=5 tests=[AWL=0.078, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.079 X-Spam-Level: X-Archive-Number: 200602/238 X-Sequence-Number: 20659 Hi, I lost two databases due to a crash of my RAID5 which resulted in a filesystem corruption. One of the two databases is the "postgres" maintenance database of which I have no backup. Is it possible to restore that database somehow without reinstalling PostgreSQL? TIA -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: J.Kraaijeveld@Askesis.nl web: www.askesis.nl