Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I restore from WAL log? [PG 7.3] - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: How can I restore from WAL log? [PG 7.3]
Date
Msg-id 20060928185851.GX34238@nasby.net
Whole thread Raw
In response to How can I restore from WAL log? [PG 7.3]  (Chan Michael <michael_kychan@yahoo.com.hk>)
Responses 回覆： Re: How can I restore from WAL log? [PG 7.3]  (Chan Michael <michael_kychan@yahoo.com.hk>)
List pgsql-admin
Tree view 
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
thedoc 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)

pgsql-admin by date:

Previous
From: "Talha Khan"
Date:
Subject: Re: transaction id wraparound
Next
From: Brad Nicholson
Date:
Subject: Re: What Are Last Steps Performed When PostgreSQL