Re: Applying logical replication changes by more than one process - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Applying logical replication changes by more than one process
Date
Msg-id 20160321132517.GA29022@awork2.anarazel.de
Whole thread Raw
In response to Re: Applying logical replication changes by more than one process  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: Applying logical replication changes by more than one process
List pgsql-hackers
On 2016-03-21 14:18:27 +0100, Petr Jelinek wrote:
> On 21/03/16 14:15, Andres Freund wrote:
> >>Only when the origin is actually setup for the current session. You
> >>need
> >>to call the replorigin_advance yourself from your apply code.
> >
> >That's problematic from a durability POV.
> >
> 
> Huh? How come?

If you use the session mechanism the replication progress is synced with
the apply process, even if there are crashes. Crash recovery updates the
progress.  There's no such interlock with apply otherwise, and I don't
see how you can build one with reasonable effort.



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Applying logical replication changes by more than one process
Next
From: Petr Jelinek
Date:
Subject: Re: Applying logical replication changes by more than one process