Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 124839FB1BA for ; Thu, 28 Sep 2006 11:16:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44006-08 for ; Thu, 28 Sep 2006 11:16:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web30502.mail.mud.yahoo.com (web30502.mail.mud.yahoo.com [68.142.200.115]) by postgresql.org (Postfix) with SMTP id 2A78C9FAE4E for ; Thu, 28 Sep 2006 11:16:21 -0300 (ADT) Received: (qmail 70634 invoked by uid 60001); 28 Sep 2006 14:16:19 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.hk; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=uBr17jI6IRrh5VqKtyVR+eVgslvivBpgCsHIpopds5TZtXSEqNOaBc5wpxVtLITDx0sJc5l8gVCtSPfiTvJsSftSHa4/FP9Uop9m9ULaXjK7gmYoIPVsQ1LzPkRcSBHH4xXSIEKlA+KkLTupP0ipjt2hYk3S3UIUdSFWO1N8Bvc= ; Message-ID: <20060928141619.70631.qmail@web30502.mail.mud.yahoo.com> Received: from [210.0.181.58] by web30502.mail.mud.yahoo.com via HTTP; Thu, 28 Sep 2006 22:16:19 CST Date: Thu, 28 Sep 2006 22:16:19 +0800 (CST) From: Chan Michael Subject: How can I restore from WAL log? [PG 7.3] To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-388907167-1159452979=:68641" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.996 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_00_10, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200609/334 X-Sequence-Number: 23248 --0-388907167-1159452979=:68641 Content-Type: text/plain; charset=big5 Content-Transfer-Encoding: 8bit Hi, I am new to PostgreSQL and now want to know how can I recover from a database crash. I know pg_dump and pg_restore but with pg_dump all transactions between every pg_dump will be lost. I found WAL in the doc and seems with it I can archieve point-in-time recovery. But I don't know the exact steps of doing this. Any input, link or tutorials will be greatly appreciated. Thanks in advance. Michael _______________________________________ YM - 離線訊息 就算你沒有上網,你的朋友仍可以留下訊息給你,當你上網時就能立即看到,任何說話都冇走失。 http://messenger.yahoo.com.hk --0-388907167-1159452979=:68641 Content-Type: text/html; charset=big5 Content-Transfer-Encoding: 8bit Hi,

I am new to PostgreSQL and now want to know how can I recover from a database crash.

I know pg_dump and pg_restore but with pg_dump all transactions between every pg_dump will be lost. I found WAL in the doc and seems with it I can archieve point-in-time recovery. But I don't know the exact steps of doing this.

Any input, link or tutorials will be greatly appreciated.

Thanks in advance.

Michael

_______________________________________
YM - 離線訊息
就算你沒有上網,你的朋友仍可以留下訊息給你,當你上網時就能立即看到,任何說話都冇走失。
http://messenger.yahoo.com.hk --0-388907167-1159452979=:68641--