Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1
Date: 2013-11-21 00:36:46
Message-ID: 72AFBD6A-D4CC-4972-9972-31F5BA7DAD48@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Nov 20, 2013, at 3:57 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:

> On 2013-11-20 15:52:22 -0800, Josh Berkus wrote:
>> Oh, so this doesn't just happen when the base backup is first taken;
>> *any* time the standby is restarted, it can happen. (!!!)
>
> Yes.

So, to be completely clear, any secondary running the affected versions which is started with hot_standby=on could potentially be corrupted even if it never connects to a primary?

--
-- Christophe Pettus
xof(at)thebuild(dot)com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-11-21 00:38:51 Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1
Previous Message Tatsuo Ishii 2013-11-21 00:36:26 Re: Can we trust fsync?