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-09 17:50:45
Message-ID: CADK3HHKpjEPQEHv8h1hj07REUQLHnN_KeSSeszYOkcq_YG=0vQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

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

Dave Cramer

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ghiureai 2018-03-09 19:55:36 streaming replication and wal 's usages
Previous Message ALEXANDER JOSE 2018-03-09 16:17:52 Re: How to identify users with super privilegies in postgress ?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2018-03-09 19:56:51 [pgjdbc/pgjdbc] 582785: tests: UUID vs setString test
Previous Message Craig Ringer 2018-03-09 01:55:53 Re: Logical WAL streaming & START_REPLICATION