Re: How to Qualifying or quantify risk of loss in asynchronous replication

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to Qualifying or quantify risk of loss in asynchronous replication
Date: 2016-03-16 22:24:09
Message-ID: 20160316222409.GG1994@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 16, 2016 at 10:40:03PM +0100, otheus uibk wrote:
> Somehow, the documentation misleads (me) to believe the async replication
> algorithm at least guarantees WAL records are *sent* before responding
> "committed" to the client. I now know this is not the case. *grumble*.
>
> How can I help make the documentation clearer on this point?

Well, I never had the understanding you apparently do, but you're
right that it's important to be clear. If there were an additional
sentence, "Note that, in any available async option, the client can
receive a message that data is committed before any replication of the
data has commenced," would that help?

Best regards,

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-03-16 22:51:13 Re: How to Qualifying or quantify risk of loss in asynchronous replication
Previous Message Dang Minh Huong 2016-03-16 22:16:37 Re: log temp files are created twice in PL/pgSQL function