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.
> 
> Is that intentional or an oversight that should be fixed?

It's intentional. WAL replay works at a lower level, it has no knowledge
of operators or the concept of uniqueness.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

In response to

• WAL replay does not verify integrity at 2010-03-02 08:18:48 from Albe Laurenz

pgsql-hackers by date

Next:	From: Ivan Sergio Borgonovo	Date: 2010-03-02 10:06:16
	Subject: Re: dedebugging and a functions that just don't work on debian flavour
Previous:	From: Greg Stark	Date: 2010-03-02 09:49:31
	Subject: Re: Hung postmaster (8.3.9)