Re: [HACKERS] WAL's single point of failure: latest CHECKPOINT record

2001-03-01 Thread Bruce Momjian
We really need point-in-time recovery, removal of the need to vacuum, and more full-featured replication. Hopefully most can be addressed in 7.2. > Hi all, > > Out of curiosity, does anyone know of any projects that are presently > creating PostgreSQL database recovery tools? > > For example d

Re: [HACKERS] WAL's single point of failure: latest CHECKPOINT record

2001-03-01 Thread Justin Clift
Hi all, Out of curiosity, does anyone know of any projects that are presently creating PostgreSQL database recovery tools? For example database corruption recovery, Point In Time restoration, and such things? It might be a good project for GreatBridge to look into if no-one else is doing it alr

[HACKERS] WAL's single point of failure: latest CHECKPOINT record

2001-03-01 Thread Tom Lane
As the WAL stuff is currently constructed, the system will refuse to start up unless the checkPoint field of pg_control points at a valid checkpoint record in the WAL log. Now I know we write and fsync the checkpoint record before we rewrite pg_control, but this still leaves me feeling mighty unc