暂无图片
pgbouncer配置文件修改后,并加载后,pool_mode字段为空
我来答
分享
暂无图片 匿名用户
pgbouncer配置文件修改后,并加载后,pool_mode字段为空

修改配置文件并重新加载

pgbouncer@[local]:6432=#-40900961 reload
pgbouncer-# ;
RELOAD
pgbouncer@[local]:6432=#-40900961 
pgbouncer@[local]:6432=#-40900961 show databases;
name | appdb
host | 192.168.100.29
port | 5432
database | postgres
force_user | 
pool_size | 20
min_pool_size | 0
reserve_pool | 0
pool_mode | 
max_connections | 0
current_connections | 0
paused | 0
disabled | 0

配置文件中部分内容:

#pool_mode = session
pool_mode = transaction

原理默认是session,我修改成事务了,并且reload了,怎么查看pool_mode没有显示内容?? 

pg-13,PgBouncer 1.17.0

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
刘贵宾

show config;

命令执行看下

暂无图片 评论
暂无图片 有用 1
手机用户9375
2022-09-17
name | pgbouncer host | port | 6432 database | pgbouncer force_user | pgbouncer pool_size | 2 min_pool_size | 0 reserve_pool | 0 pool_mode | statement max_connections | 0 current_connections | 0 paused | 0 disabled | 0
手机用户9375
2022-09-17
[databases] appdb = host=192.168.100.29 dbname=postgres port=5432 [pgbouncer] logfile = /opt/postgreSQL/pgbouncer/log/pgbouncer.log pidfile = /opt/postgreSQL/pgbouncer/pid/pgbouncer.pid listen_addr = * listen_port = 6432 auth_type = trust auth_file = /opt/postgreSQL/pgbouncer/user.txt admin_users = postgres stats_users = postgres pool_mode = transaction server_reset_query = DISCARD ALL max_client_conn = 100 default_pool_size = 20
手机用户9375
2022-09-17
配置文件中是pool_mode = transaction,show databases后,却显示pool_mode | statement ,不理解了??
刘贵宾

你执行show config;命令pool_mode显示的什么?

暂无图片 评论
暂无图片 有用 1
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏