Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How can I restore from WAL log? [PG 7.3]
- From: "Jim C. Nasby" <jim(at)nasby(dot)net>
- To: Chan Michael <michael_kychan(at)yahoo(dot)com(dot)hk>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: How can I restore from WAL log? [PG 7.3]
- Date: Thu, 28 Sep 2006 13:58:51 -0500
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(at)nasby(dot)net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
- Follow-Ups:
- 回覆： Re: How can I restore from WAL log? [PG 7.3]
- From: Chan Michael
- 回覆： Re: How can I restore from WAL log? [PG 7.3]
- References:
- How can I restore from WAL log? [PG 7.3]
- From: Chan Michael
- How can I restore from WAL log? [PG 7.3]
- Prev by Date: Re: transaction id wraparound
- Next by Date: Re: What Are Last Steps Performed When PostgreSQL
- Previous by thread: How can I restore from WAL log? [PG 7.3]
- Next by thread: 回覆： Re: How can I restore from WAL log? [PG 7.3]
- Indexes: