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 8BF1C3ABE87 for ; Wed, 22 Dec 2004 18:11:05 +0000 (GMT) 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 81801-07 for ; Wed, 22 Dec 2004 18:10:56 +0000 (GMT) Received: from web60406.mail.yahoo.com (web60406.mail.yahoo.com [216.109.118.189]) by svr1.postgresql.org (Postfix) with SMTP id D41953ABE01 for ; Wed, 22 Dec 2004 18:10:56 +0000 (GMT) Received: (qmail 59920 invoked by uid 60001); 22 Dec 2004 18:10:54 -0000 Message-ID: <20041222181054.59918.qmail@web60406.mail.yahoo.com> Received: from [24.72.130.222] by web60406.mail.yahoo.com via HTTP; Wed, 22 Dec 2004 13:10:54 EST Date: Wed, 22 Dec 2004 13:10:54 -0500 (EST) From: jennifer fan Subject: restore data from DB base? To: pgsql-admin@postgresql.org In-Reply-To: <20041222175448.44C245AF393@svr4.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-620256400-1103739054=:59891" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.29 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, HTML_10_20, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200412/225 X-Sequence-Number: 15811 --0-620256400-1103739054=:59891 Content-Type: text/plain; charset=us-ascii One server that hold postgresql(7.4.6) and data(account system data) stop working yesterday, the disks may be demaged. the data wasn't backuped. Does anybody know how to restore data from DB base. That means, if the data directory could be found from disk, is it possiple to install a postgresql(7.4.6) in a new machine, copy data directory to new machine, then try to restore data ? But how to ask postgresql knew the data directory? Any suggestion will very be apperciate. Thanks --------------------------------- Post your free ad now! Yahoo! Canada Personals --0-620256400-1103739054=:59891 Content-Type: text/html; charset=us-ascii

One server that hold postgresql(7.4.6) and data(account system data) stop working yesterday, the disks may be demaged. the data wasn't backuped.  Does anybody know how to restore data from DB base. That means, if the data directory could be found from disk, is it possiple to install  a postgresql(7.4.6) in a new machine, copy data directory to new machine, then try to restore data ? But how to ask postgresql knew the data directory?  Any suggestion will very be apperciate.

Thanks

 

 



Post your free ad now! Yahoo! Canada Personals
--0-620256400-1103739054=:59891--