WAL replay does not verify integrity

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: WAL replay does not verify integrity
Date: 2010-03-02 08:18:48
Message-ID: D960CB61B694CF459DCFB4B0128514C2039381C8@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gokulakannan Somasundaram 2010-03-02 09:04:10 Re: A thought on Index Organized Tables
Previous Message Joshua D. Drake 2010-03-02 08:11:33 Re: pg_stop_backup does not complete