Re: [HACKERS] WAL replay does not verify integrity

2010-03-02 Thread Heikki Linnakangas
Albe Laurenz wrote: > As demonstrated here: > http://archives.postgresql.org/pgsql-general/2010-02/msg01057.php > > it can happen that you end up with a corrupt database > if you use PITR to recover past a hardware failure. > > It seems that unique constraints are not verified during > WAL replay

[HACKERS] WAL replay does not verify integrity

2010-03-02 Thread Albe Laurenz
As demonstrated here: http://archives.postgresql.org/pgsql-general/2010-02/msg01057.php it can happen that you end up with a corrupt database if you use PITR to recover past a hardware failure. It seems that unique constraints are not verified during WAL replay. Is that intentional or an oversig