Re: How can I restore from WAL log? [PG 7.3]

From: "Jim C(dot) 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: 2006-09-28 18:58:51
Message-ID: 20060928185851.GX34238@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Brad Nicholson 2006-09-28 19:18:05 Re: What Are Last Steps Performed When PostgreSQL
Previous Message Talha Khan 2006-09-28 18:58:12 Re: transaction id wraparound