RE: Recovery of PGSQL after system crash failing!!! - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Recovery of PGSQL after system crash failing!!!
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D32F2@sectorbase1.sectorbase.com
Whole thread Raw
In response to Recovery of PGSQL after system crash failing!!!  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
Responses RE: Recovery of PGSQL after system crash failing!!!  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
List pgsql-hackers
> Might it be, that pg_control is older than it should be ?
> I mean, that the write to pg_control did not make it to disk,
> but the checkpoint already completed (removed the logs) ?

Well, WAL does *pg_fsync()* of pg_control before removing old
logs, so it's only possible if Ryan run PG with -F (fsync = off).
Ryan?

Vadim


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: ODBC talking to <=6.3 servers
Next
From: "Rod Taylor"
Date:
Subject: NEW and OLD in EXECUTE