auth_type = md5 auth_file = /home/postgres/pgbouncer/bin/userlist.txt logfile = /home/postgres/pgbouncer/pgbouncer1.log pidfile =/home/postgres/pgbouncer/pgbouncer1.pid unix_socket_dir = /tmp ;;unix_socket_mode = 0777 admin_users = wzb stats_users = wzb pool_mode = session max_client_...
user:指定启动PgBouncer的用户名,windows系统不支持此设置 auth_type:认证的类型,默认是trust,其他值包括md5,crypt,plain,any。用得较多的是md5 auth_file:认证文件的位置,默认值是/etc/pgbouncer/userlist.txt pool_mode:指定池的模式,默认是session模式,还可以是transaction和statement max_client_conn:允许的最大连...
auth_type = trust ;;;pgbouncer密码文件,和数据库用户对应即可。 auth_file = /data/pg listen_addr = * listen_port = 5766 密码文件 cat /data/pg "appuser" "1qaz@WSX" 输入不存在的用户(密码文件不存在,数据不存在。) 密码文件(auth_file)用户不存在;(错误信息:用户不存在) psql -h db01 -p ...
unix_socket_group = auth_type = trust auth_file = /opt/pgbouncer/share/doc/pgbouncer/userlist.txt ; 此处auth_type 可以配置md5,但是数据库侧的 pg_hba.conf文件也需要配置为md5,且userlist 配置文件就需要存md5 后的密码,不能配置为明文,如果设置为trust,则需要设置为明文。 pool_mode = transaction ;...
auth_type = md5 auth_file = /home/postgres/pgbouncer/bin/userlist.txt logfile = /home/postgres/pgbouncer/pgbouncer1.log pidfile =/home/postgres/pgbouncer/pgbouncer1.pid unix_socket_dir = /tmp ;;unix_socket_mode = 0777 admin_users = wzb ...
auth_file中的用户即访问后端真实postgresql数据库中的所需要的用户。 auth_type 配置为md5是会自动兼容md5和scram-sha-256两种加密方式。PG14之后默认scram-sha-256。可通过select usename,passwd from pg_shadow order by 1;查看。 日志文件路径要提前创建mkdir /usr/local/pgbouncer/log ...
auth_type = md5 auth_file = /home/postgres/pgbouncer/bin/userlist.txt logfile = /home/postgres/pgbouncer/pgbouncer.log pidfile =/home/postgres/pgbouncer/pgbouncer.pid admin_users = wzb stats_users = wzb pool_mode = session max_client_conn=1000 ...
auth_type = md5 auth_file = /home/postgres/pgbouncer/user.txt logfile = /home/postgres/pgbouncer/pgbouncer.log pidfile = /home/postgres/pgbouncer/pgbouncer.pid admin_users = u_kenyon pool_mode = Transaction 2.配置用户密码文件users.txt
[databases]sbtest = host=127.0.0.1 port=5432 dbname=sbtest [pgbouncer]listen_port = 6543listen_addr = 127.0.0.1auth_type = md5auth_file = userslist.txtlogfile = pgbouncer.logpidfile = pgbouncer.pidadmin_users = postgrespool_mode = transactiondefault_pool_size=56max_client_conn=600 ...
auth_type = md5 auth_file = userslist.txt logfile = pgbouncer.log pidfile = pgbouncer.pid admin_users = postgres pool_mode = transaction default_pool_size=56 max_client_conn=600 除了pool_mode以外,其他最重要的变量是: default_pool_size:每个用户/数据库对允许多少个服务器连接。