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

Re: WAL replay does not verify integrity

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WAL replay does not verify integrity
Date: 2010-03-02 09:58:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Albe Laurenz wrote:
> 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?

It's intentional. WAL replay works at a lower level, it has no knowledge
of operators or the concept of uniqueness.

  Heikki Linnakangas

In response to

pgsql-hackers by date

Next:From: Ivan Sergio BorgonovoDate: 2010-03-02 10:06:16
Subject: Re: dedebugging and a functions that just don't work on debian flavour
Previous:From: Greg StarkDate: 2010-03-02 09:49:31
Subject: Re: Hung postmaster (8.3.9)

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