 |
Nt6Z1gV2EX 第 376038 号会员，加入于 2019-01-08 14:12:29 +08:00 |
Nt6Z1g 最近回复了
19 天前 回复了 Koril 创建的主题 › PostgreSQL › 请教一个关于 PostgreSQL 连接被 Server 关闭的问题 |
印象中阿里云服务器修改了 OS 的 tcp_keepalive 参数, pg 默认用系统的参数会导致这个问题. 你手动设置 pg 的 tcp_keepalive 参数试试. 比如
```
select name,setting from pg_settings where name like 'tcp_keepalives%';
ALTER SYSTEM set tcp_keepalives_idle = 600;
ALTER SYSTEM set tcp_keepalives_interval = 30;
ALTER SYSTEM set tcp_keepalives_count = 10;
SELECT pg_reload_conf();
```
```
select name,setting from pg_settings where name like 'tcp_keepalives%';
ALTER SYSTEM set tcp_keepalives_idle = 600;
ALTER SYSTEM set tcp_keepalives_interval = 30;
ALTER SYSTEM set tcp_keepalives_count = 10;
SELECT pg_reload_conf();
```
Select Language