Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6B56A9FC6D3 for ; Thu, 12 Apr 2007 01:35:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 90903-03-2 for ; Thu, 12 Apr 2007 01:35:28 -0300 (ADT) X-Greylist: delayed 01:15:53.751545 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 337BA9FC721 for ; Thu, 12 Apr 2007 01:20:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ucsns.ucs.co.za (ucsns.ucs.co.za [196.23.43.2]) by svr4.postgresql.org (Postfix) with ESMTP id B8D1B5B05A7 for ; Tue, 10 Apr 2007 08:50:05 +0000 (GMT) Received: from ucspost.ucs.co.za (ucspost.ucs.co.za [196.23.43.3]) by ucsns.ucs.co.za (Postfix) with ESMTP id 972712BD4C for ; Tue, 10 Apr 2007 10:49:22 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id E7BFD18A77D for ; Tue, 10 Apr 2007 10:49:22 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with ESMTP id 987D7550AE for ; Tue, 10 Apr 2007 10:49:22 +0200 (SAST) Date: Tue, 10 Apr 2007 10:49:49 +0200 From: Stef To: pgsql-admin@postgresql.org Subject: Restoring postgres from data directory. Message-ID: <20070410104949.148fdadf@svb.ucs.co.za> X-Mailer: Sylpheed-Claws 2.6.0 (GTK+ 2.8.20; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200704/114 X-Sequence-Number: 25178 Hi all, I've got a postgres 7.3.4 database. and somehow the pg_control file got corrupted when the machine ran out of space, and someone ran pg_resetxlog -f. So basically the database starts up, but I can only see template1 and template0. Is there a way to link in the data that is in the "base" directory so that postgres sees that database again? Kind Regards Stefan -- Confidentiality Notice: http://ucs.co.za/conf.html