Re: WAL Question

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Harry Yau <harry(at)regaltronic(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WAL Question
Date: 2001-07-04 18:20:56
Message-ID: Pine.LNX.4.30.0107042020140.679-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Harry Yau writes:

> tell me about the flow of the process to recover from WAL: 1. reads
> pg_control, 2. reads checkpoint record, 3. reads redo record, and then
> finally 4. REDO operation. I wonder do we need to run all the above
> procedures manually, after a crash?? or They will REALLY be
> automatically run when re-start the postgres after a crash?? It sounds
> like a miracle for me!!

Everything is automatic.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dennis 2001-07-06 22:34:30 Disk Page Fetches
Previous Message Henshall, Stuart - WCP 2001-07-04 08:23:55 RE: HELP PLEASE!! Installation on NT Machine.