1) 配置文件,postgresql.conf,添加:shared_preload_libraries = 'pg_timeout' 2) 两个参数: pg_timeout.naptime: numberofsecondsforthe dedicated backgroud workertosleep between idle session checks (defaultvalueis10seconds) pg_timeout.idle_session_timeout: database session idle timeoutinseconds (defaultva...
1、超时参数 2、pg_timeout 插件 2.1 安装 CompilingThis module can be built using the standard PGXS infrastructure.Forthistowork, the pg_config program must be availableinyour $PATH: git clone https://github.com/pierreforstmann/pg_timeout.git cd pg_timeout make make install This extension ha...