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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
