Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C4BD09FB2F0 for ; Thu, 28 Sep 2006 23:24:13 -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 36896-02 for ; Thu, 28 Sep 2006 23:24:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web30504.mail.mud.yahoo.com (web30504.mail.mud.yahoo.com [68.142.200.117]) by postgresql.org (Postfix) with SMTP id 44E739FB2D1 for ; Thu, 28 Sep 2006 23:24:04 -0300 (ADT) Received: (qmail 2601 invoked by uid 60001); 29 Sep 2006 02:24:02 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.hk; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=V0baMYL6hNqv094BnDOb4L2BluH+TzNPYlyFmEYjDQDR+KDui/TpE1nkyqZhPn64SfiCBcz8NtHA2KZQhUOpQisRewSkHnviwlgHX8bf0zbkk8I1GeUfbX2TYMJs9Bv/uHLtBDyFqCZv6yzy7Oj8wbHJpxU5DoRVCmKpdA0IV0A= ; Message-ID: <20060929022401.2599.qmail@web30504.mail.mud.yahoo.com> Received: from [210.0.181.58] by web30504.mail.mud.yahoo.com via HTTP; Fri, 29 Sep 2006 10:24:01 CST Date: Fri, 29 Sep 2006 10:24:01 +0800 (CST) From: Chan Michael Subject: =?big5?q?=A6^=C2=D0=A1G=20Re:=20=20How=20can=20I=20restore=20from?= =?big5?q?=20WAL=20log=3F=20[PG=207.3]?= To: "Jim C. Nasby" Cc: pgsql-admin@postgresql.org In-Reply-To: <20060928185851.GX34238@nasby.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-100655090-1159496641=:2140" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.36 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, SUBJECT_ENCODED_TWICE X-Spam-Level: * X-Archive-Number: 200609/357 X-Sequence-Number: 23271 --0-100655090-1159496641=:2140 Content-Type: text/plain; charset=big5 Content-Transfer-Encoding: 8bit Hi Jim, Thanks for your info. Then in PostgreSQL 7.3 how can I use the WAL log to recover? Michael "Jim C. Nasby" 說: On Thu, Sep 28, 2006 at 10:16:19PM +0800, Chan Michael wrote: > 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. Point in Time Recovery wasn't added until version 8.0. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) _______________________________________ YM - 離線訊息 就算你沒有上網,你的朋友仍可以留下訊息給你,當你上網時就能立即看到,任何說話都冇走失。 http://messenger.yahoo.com.hk --0-100655090-1159496641=:2140 Content-Type: text/html; charset=big5 Content-Transfer-Encoding: 8bit Hi Jim,

Thanks for your info.

Then in PostgreSQL 7.3  how can I use the WAL log to recover?

Michael

"Jim C. Nasby" <jim@nasby.net> 說:
On Thu, Sep 28, 2006 at 10:16:19PM +0800, Chan Michael wrote:
> 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.

Point in Time Recovery wasn't added until version 8.0.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

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