Re: [HACKERS] Replication status in logical replication - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: [HACKERS] Replication status in logical replication
Date
Msg-id CAD21AoAKOZdTG45Lf-hd9AyDhRcwRcuOawF17MwXXqAp-bvJvg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Replication status in logical replication  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [HACKERS] Replication status in logical replication  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
On Wed, Apr 12, 2017 at 5:31 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 22 March 2017 at 02:50, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
>> When using logical replication, I ran into a situation where the
>> pg_stat_replication.state is not updated until any wal record is sent
>> after started up. For example, I set up logical replication with 2
>> subscriber and restart the publisher server, but I see the following
>> status for a while (maybe until autovacuum run).
> ...
>
>> Attached patch fixes this behavior by updating WalSndCaughtUp before
>> trying to read next WAL if already caught up.
>
> Looks like a bug that we should fix in PG10, with backpatch to 9.4 (or
> as far as it goes).
>
> Objections to commit?
>

Seems we still have this issue. Any update or comment on this? Barring
any objections, I'll add this to the open item so it doesn't get
missed.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgindent (was Re: [HACKERS] [COMMITTERS] pgsql: Preventive maintenance in advance of pgindent run.)
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: Re: [HACKERS] [bug fix] PG10: libpq doesn't connect to alternativehosts when some errors occur