Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6650B9FB35F for ; Thu, 28 Sep 2006 15:59:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 87469-03 for ; Thu, 28 Sep 2006 18:58:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id C22A09FB35B for ; Thu, 28 Sep 2006 15:58:52 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id B971956435; Thu, 28 Sep 2006 13:58:51 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 28 Sep 2006 13:58:51 -0500 Date: Thu, 28 Sep 2006 13:58:51 -0500 From: "Jim C. Nasby" To: Chan Michael Cc: pgsql-admin@postgresql.org Subject: Re: How can I restore from WAL log? [PG 7.3] Message-ID: <20060928185851.GX34238@nasby.net> References: <20060928141619.70631.qmail@web30502.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060928141619.70631.qmail@web30502.mail.mud.yahoo.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060928:michael_kychan@yahoo.com.hk::Wv3SKnlmCFahk3ea:0000000000 0000000000000000000000001bDZ X-Hashcash: 1:20:060928:pgsql-admin@postgresql.org::t0E8zsOfYdb31nZI:00000000000 0000000000000000000000001oVw X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/340 X-Sequence-Number: 23254 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)