From: "Albe Laurenz" on
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?

Yours,
Laurenz Albe

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers