WAL replay does not verify integrity - Mailing list pgsql-hackers

From Albe Laurenz
Subject WAL replay does not verify integrity
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2039381C8@exadv11.host.magwien.gv.at
Whole thread Raw
Responses Re: WAL replay does not verify integrity
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pg_stop_backup does not complete
Next
From: Gokulakannan Somasundaram
Date:
Subject: Re: A thought on Index Organized Tables