Re: Logical WAL streaming & START_REPLICATION

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Joe Hammerman <jhammerman(at)squarespace(dot)com>, pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Re: Logical WAL streaming & START_REPLICATION
Date: 2018-03-10 12:53:25
Message-ID: CADK3HHKJ=-07sqjujufVC21KHU1PSXoEBvRfNom5uymaO-179g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

On 10 March 2018 at 04:44, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:

> On 10 March 2018 at 01:50, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
>>
>>
>> On 9 March 2018 at 01:55, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
>>
>>> On 9 March 2018 at 09:50, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
>>>
>>>
>>>> If your system will forget work on crash, it's not flushed, and you
>>>> shouldn't report it flushed.
>>>>
>>>>
>>> I haven't checked to see if PgJDBC actually exposes separate control of
>>> the reported flush position though. If it doesn't, it really must in order
>>> to make replication slots work properly.
>>>
>>
>> Yes, we have separate control
>>
>> https://github.com/pgjdbc/pgjdbc/blob/1be8a9ebafbfbcff118385a61a350745addcaf3d/pgjdbc/src/main/java/org/postgresql/core/v3/replication/V3PGReplicationStream.java#L97
>>
>>
>>
>>
> Great!
>
> I hope that answers your question then Joe.
>
> Dave, if you'd find it useful to add the explanation I wrote to the docs,
> please feel free to crib as desired.
>
>
Craig, good, idea.

Thanks!

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-03-12 08:57:21 Re: streaming replication and wal 's usages
Previous Message Craig Ringer 2018-03-10 12:44:44 Re: Logical WAL streaming & START_REPLICATION

Browse pgsql-jdbc by date

  From Date Subject
Next Message chalda 2018-03-11 08:40:21 [pgjdbc/pgjdbc] e5aab1: Adjust XAException return codes for better compati...
Previous Message Craig Ringer 2018-03-10 12:44:44 Re: Logical WAL streaming & START_REPLICATION