Re: Logical WAL streaming & START_REPLICATION

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: Dave Cramer <pg(at)fastcrypt(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:44:44
Message-ID: CAMsr+YEM_QhxkhAS2g8LdPGjFDC9wLwk5BF-5t7-ZD6KQ6_6yA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

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 Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Cramer 2018-03-10 12:53:25 Re: Logical WAL streaming & START_REPLICATION
Previous Message ghiureai 2018-03-09 19:55:36 streaming replication and wal 's usages

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2018-03-10 12:53:25 Re: Logical WAL streaming & START_REPLICATION
Previous Message Vladimir Sitnikov 2018-03-10 10:49:48 [pgjdbc/pgjdbc] 44bb7f: fix: UUID test for preferQueryMode=simple