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 7D2423B5A92 for ; Fri, 24 Dec 2004 03:08:15 +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 65597-08 for ; Fri, 24 Dec 2004 03:07:46 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 10AD33B5A70 for ; Fri, 24 Dec 2004 03:07:49 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id iBO37nEl017012; Thu, 23 Dec 2004 19:07:50 -0800 Message-ID: <41CB880E.5010005@commandprompt.com> Date: Thu, 23 Dec 2004 19:07:58 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: jennifer fan Cc: pgsql-admin@postgresql.org Subject: Re: restore data from DB base? References: <20041222181054.59918.qmail@web60406.mail.yahoo.com> In-Reply-To: <20041222181054.59918.qmail@web60406.mail.yahoo.com> Content-Type: multipart/mixed; boundary="------------080709030401050809060004" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/231 X-Sequence-Number: 15817 This is a multi-part message in MIME format. --------------080709030401050809060004 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit jennifer fan wrote: > 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. > If the data directory is intact, you should be able to move it to a new 7.4.6 postgresql installation without issue. You could then start it up with a command like this: pg_ctl -D -l start Sincerely, Joshua D. Drake > Thanks > > > > > > > ------------------------------------------------------------------------ > Post your free ad now! *Yahoo! Canada Personals* > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------080709030401050809060004 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------080709030401050809060004--