]> granicus.if.org Git - postgresql/commit
Make logical WAL sender report streaming state appropriately
authorMichael Paquier <michael@paquier.xyz>
Thu, 12 Jul 2018 01:19:51 +0000 (10:19 +0900)
committerMichael Paquier <michael@paquier.xyz>
Thu, 12 Jul 2018 01:19:51 +0000 (10:19 +0900)
commit0414ac6a1eb2e457c8019c5a558bd72b37dede89
tree6f89c7e1ba5a5781eb183ba9e531e1af828c1879
parent5b762d96e8c602434bc7e56f910c23c54e95f80d
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
src/backend/replication/walsender.c
src/test/perl/PostgresNode.pm
src/test/subscription/t/001_rep_changes.pl