Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 65CDB9FB711 for ; Wed, 4 Jul 2007 10:12:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 63129-09 for ; Wed, 4 Jul 2007 10:12:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1A73F9FB70F for ; Wed, 4 Jul 2007 10:12:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.nohaylimite.com (unknown [190.2.3.105]) by svr4.postgresql.org (Postfix) with ESMTP id 163C65AF897 for ; Wed, 4 Jul 2007 13:12:31 +0000 (GMT) Received: by mail.nohaylimite.com (Postfix, from userid 48) id A2847753CD; Wed, 4 Jul 2007 10:14:58 -0300 (ART) Received: from 200.1.117.15 (proxying for unknown) (SquirrelMail authenticated user marpon@marpon.com.ar) by www.nohaylimite.com with HTTP; Wed, 4 Jul 2007 10:14:58 -0300 (ART) Message-ID: <49804.200.1.117.15.1183554898.squirrel@www.nohaylimite.com> Date: Wed, 4 Jul 2007 10:14:58 -0300 (ART) Subject: Restoring a tablespace From: "Martin Arpon" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.6-3.fc5 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.135 tagged_above=0 required=5 tests=BAYES_60=1, FORGED_RCVD_HELO=0.135 X-Spam-Level: * X-Archive-Number: 200707/32 X-Sequence-Number: 26013 Hi, I have a filesystem backup (cold - database was not running) of only a single tablespace where the database was sitting. Is it possible to install a new instance of PostgreSQL and in some way "re-mount" this tablespace recovering the database that was there? The whole database was there, and there wasn't anything else. Thanks, Martin