pgbouncer工具安装使用

最新推荐文章于 2024-08-11 21:52:56 发布

arcticJian

最新推荐文章于 2024-08-11 21:52:56 发布

阅读量1.4k

点赞数

分类专栏： Postgresql pgbouncer 文章标签： postgresql pgbouncer

本文链接：https://blog.csdn.net/arcticJian/article/details/76825159

版权

本文档详细介绍了pgbouncer的安装过程，包括libevent的安装和pgbouncer的下载与配置。还阐述了环境变量配置、userlist.txt文件的设置以及启动和管理pgbouncer的命令。同时，讲解了pgbouncer的配置文件各项参数，如databases配置项、通用配置项和日志配置项等，为pgbouncer的使用提供了全面的指导。

摘要由CSDN通过智能技术生成

pgbouncer安装

安装libevent

libevent下载地址：
https://github.com/downloads/libevent/libevent/libevent-2.0.21-stable.tar.gz

安装：

# wget https://github.com/downloads/libevent/libevent/libevent-2.0.21-stable.tar.gz  
# tar -zxvf libevent-2.0.21-stable.tar.gz
# cd libevent-2.0.21-stable
# ./configure --prefix=/usr/libevent/libevent
# make
# make install

安装pgbouncer

pgbouncer下载地址：
https://pgbouncer.github.io/downloads/

# tar -zxvf pgbouncer-1.7.2.tar.gz
# cd pgbouncer-1.7.2
# ./configure --prefix=/usr/pgbouncer/ --with-libevent=/usr/libevent/libevent
# make
# make install

环境变量配置

环境变量增加如下内容：

# vi /etc/profile
 export LD_LIBRARY_PATH=/usr/libevent/libevent/lib:$LD_LIBRARY_PATH
 export PATH=$PATH:/usr/libevent/libevent/bin
# source profile

pgbouncer配置文件

# cd /usr/pgbouncer/share/doc/pgbouncer
# vi pgbouncer.ini

[databases]  
postgres=host=127.0.0.1 port=5432 user=postgres dbname=postgres pool_size=100  

[pgbouncer] 
logfile = /usr/pgbouncer/log/pgbouncer.log  
pidfile = /usr/pgbouncer/pgbouncer.pid  
admin_users = postgres  

listen_addr = 127.0.0.1
listen_port = 6432  

auth_type =