Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
As demonstrated here:

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?

Laurenz Albe


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group