pgsql: Make logical WAL sender report streaming state appropriately - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Make logical WAL sender report streaming state appropriately
Date
Msg-id E1fdQIg-000671-3r@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Make logical WAL sender report streaming state appropriately

WAL senders sending logically-decoded data fail to properly report in
"streaming" state when starting up, hence as long as one extra record is
not replayed, such WAL senders would remain in a "catchup" state, which
is inconsistent with the physical cousin.

This can be easily reproduced by for example using pg_recvlogical and
restarting the upstream server.  The TAP tests have been slightly
modified to detect the failure and strengthened so as future tests also
make sure that a node is in streaming state when waiting for its
catchup.

Backpatch down to 9.4 where this code has been introduced.

Reported-by: Sawada Masahiko
Author: Simon Riggs, Sawada Masahiko
Reviewed-by: Petr Jelinek, Michael Paquier, Vaishnavi Prabakaran
Discussion: https://postgr.es/m/CAD21AoB2ZbCCqOx=bgKMcLrAvs1V0ZMqzs7wBTuDySezTGtMZA@mail.gmail.com

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/d5eb1fe0dc717acae5da610c47468d3472d646a4

Modified Files
--------------
src/backend/replication/walsender.c | 22 ++++++++++++++++------
1 file changed, 16 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Mark built-in btree comparison functions as leakproof whereit's
Next
From: Michael Paquier
Date:
Subject: pgsql: Add assertion in expand_vacuum_rel() for non-autovacuum path