Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 52C9D9FBA49 for ; Wed, 25 Apr 2007 22:34:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 82639-04 for ; Wed, 25 Apr 2007 22:34:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.238]) by postgresql.org (Postfix) with ESMTP id 304849FBA26 for ; Wed, 25 Apr 2007 22:34:39 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so415954wra for ; Wed, 25 Apr 2007 18:34:37 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=JghbUwG4+Cw3jPHFU7Rizg9l1Mn0IOMpb2PRxgRiCi1u3J2Vkbfy3WayWmk8XqoTs9KGTVMViuyg7o5oI4d1EGZZ+fHE0gTT7BsA+Bapu0eJxyNv8UnTaRfhefhRsBGo3FCosev3ztZOYG6rVr5p9oaMU5Nazl5vTpif47m17A0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=oJTHx4kJ5LjGTH50DY6vKOIIbjRFE7p5WvQuZgWII0xvhs/664Lc7hwsOX7GtGx0VUkzSKsc26mJtuFLrceqPkHxmLIjzK5STsTlD3m4lcUDZy4n6sP5RbZiDyjuc8yxRVPkJj32jEmpk61cQC4FLWnYUuFu6Ix9m1MqGQWi7Mc= Received: by 10.114.150.1 with SMTP id x1mr417609wad.1177551277267; Wed, 25 Apr 2007 18:34:37 -0700 (PDT) Received: by 10.114.38.11 with HTTP; Wed, 25 Apr 2007 18:34:37 -0700 (PDT) Message-ID: <474404120704251834j8f8ab98sdbdf3ef80b0ff179@mail.gmail.com> Date: Thu, 26 Apr 2007 09:34:37 +0800 From: "Gera Mel Handumon" To: pgsql-admin@postgresql.org Subject: Restoring database from Tablespace MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/242 X-Sequence-Number: 25306 Hi! My XP was corrupted. I can no longer run the pgdump. The tablespace is in other drive. Is it possible to restore the database using only the data in my tablespace? What's the work-around in this problem? thanks in advance... Mel