PostgreSQL参数—wal_sender_timeout

PostgreSQL参数—wal_sender_timeout

参数说明

postgres=# show wal_sender_timeout;
 wal_sender_timeout 
--------------------
 1min
(1 row)

postgres=# \x
Expanded display is on.
postgres=# select * from pg_settings where name = 'wal_sender_timeout';
-[ RECORD 1 ]---+---------------------------------------------------
name            | wal_sender_timeout
setting         | 60000
unit            | ms
category        | Replication / Sending Servers
short_desc      | Sets the maximum time to wait for WAL replication.
extra_desc      | 
context         | user
vartype         | integer
source          | default
min_val         | 0
max_val         | 2147483647
enumvals        | 
boot_val        | 60000
reset_val       | 60000
sourcefile      | 
sourceline      | 
pending_restart | f

postgres=# 

参数设置

postgres=# set wal_sender_timeout = 120000;
SET
postgres=# show wal_sender_timeout;
 wal_sender_timeout 
--------------------
 2min
(1 row)

postgres=# 

参数含义

本参数指定处于inactive状态多长时间之后，终止掉复制连接。

较小的本参数值有助于快速的连接故障检测；

较高的本参数值有助于判断standby server的健康状况。