]> granicus.if.org Git - postgresql/commit
Improve replication connection timeouts.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 11 Oct 2012 14:39:52 +0000 (17:39 +0300)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 11 Oct 2012 14:48:08 +0000 (17:48 +0300)
commit6f60fdd7015b032bf49273c99f80913d57eac284
treeef9a5602c01617665815503a45dc1ea3b379e757
parent8521d131941be5a177270bc428fa8e684cd645b5
Improve replication connection timeouts.

Rename replication_timeout to wal_sender_timeout, and add a new setting
called wal_receiver_timeout that does the same at the walreceiver side.
There was previously no timeout in walreceiver, so if the network went down,
for example, the walreceiver could take a long time to notice that the
connection was lost. Now with the two settings, both sides of a replication
connection will detect a broken connection similarly.

It is no longer necessary to manually set wal_receiver_status_interval to
a value smaller than the timeout. Both wal sender and receiver now
automatically send a "ping" message if more than 1/2 of the configured
timeout has elapsed, and it hasn't received any messages from the other end.

Amit Kapila, heavily edited by me.
doc/src/sgml/config.sgml
doc/src/sgml/release-9.1.sgml
src/backend/replication/walreceiver.c
src/backend/replication/walsender.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/include/replication/walprotocol.h
src/include/replication/walreceiver.h
src/include/replication/walsender.h
src/include/replication/walsender_private.h