Re: WAL Question - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: WAL Question
Date
Msg-id Pine.LNX.4.30.0107042020140.679-100000@peter.localdomain
Whole thread Raw
In response to WAL Question  (Harry Yau <harry@regaltronic.com>)
List 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@gmx.net   http://funkturm.homeip.net/~peter


pgsql-admin by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: RE: HELP PLEASE!! Installation on NT Machine.
Next
From: "Sudheer Palaparambil"
Date:
Subject: RUNNING STANDALONE