Horton

RE: Recovery of PGSQL after system crash failing!!!

Vadim Mikheev <vmikheev@sectorbase.com>

View thread
From: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
To: "'Zeugswetter Andreas SB'" <ZeugswetterA@wien.spardat.at>, Ryan Kirkpatrick <pgsql@rkirkpat.net>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2001-02-13T18:11:31Z
Lists: 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