postgresql参数—wal-m6米乐安卓版下载

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的健康状况。