yum install libevent -y

yum install libevent-devel -y

wget http://www.pgbouncer.org/downloads/files/1.11.0/pgbouncer-1.11.0.tar.gz

tar -xvf pgbouncer-1.11.0.tar.gz

./configure --prefix=/usr/local --with-libevent=libevent-prefix

make

make install

cat /etc/pgbouncer/pgbouncer.ini

[databases]

postgres = host=127.0.0.1 port=5432 dbname=postgres 

[pgbouncer]

logfile = /var/log/pgbouncer/pgbouncer.log

pidfile = /var/run/pgbouncer/pgbouncer.pid

listen_addr = 192.168.216.130

listen_port = 6432

unix_socket_dir = /var/run/postgresql

auth_type = md5

auth_file = /etc/pgbouncer/userlist.txt

admin_users = postgres

ignore_startup_parameters = extra_float_digits,geqo

pool_mode = session

server_reset_query = DISCARD ALL

max_client_conn = 10000

default_pool_size = 10

reserve_pool_size = 1

reserve_pool_timeout = 1

max_db_connections = 1000

pkt_buf = 8192

# Documentation https://pgbouncer.github.io/config.html

cat /etc/pgbouncer/userlist.txt

"postgres" "postgres-pass"

cat /etc/pgbouncer/pgbouncer.ini

[databases]

postgres = host=127.0.0.1 port=5432 dbname=postgres 

[pgbouncer]

logfile = /var/log/pgbouncer/pgbouncer.log

pidfile = /var/run/pgbouncer/pgbouncer.pid

listen_addr = 192.168.216.132

listen_port = 6432

unix_socket_dir = /var/run/postgresql

auth_type = md5

auth_file = /etc/pgbouncer/userlist.txt

admin_users = postgres

ignore_startup_parameters = extra_float_digits,geqo

pool_mode = session

server_reset_query = DISCARD ALL

max_client_conn = 10000

default_pool_size = 10

reserve_pool_size = 1

reserve_pool_timeout = 1

max_db_connections = 1000

pkt_buf = 8192

# Documentation https://pgbouncer.github.io/config.html

cat /etc/pgbouncer/userlist.txt

"postgres" "postgres-pass"

cat /etc/pgbouncer/pgbouncer.ini

[databases]

postgres = host=127.0.0.1 port=5432 dbname=postgres 

[pgbouncer]

logfile = /var/log/pgbouncer/pgbouncer.log

pidfile = /var/run/pgbouncer/pgbouncer.pid

listen_addr = 192.168.216.134

listen_port = 6432

unix_socket_dir = /var/run/postgresql

auth_type = md5

auth_file = /etc/pgbouncer/userlist.txt

admin_users = postgres

ignore_startup_parameters = extra_float_digits,geqo

pool_mode = session

server_reset_query = DISCARD ALL

max_client_conn = 10000

default_pool_size = 10

reserve_pool_size = 1

reserve_pool_timeout = 1

max_db_connections = 1000

pkt_buf = 8192

# Documentation https://pgbouncer.github.io/config.html

cat /etc/pgbouncer/userlist.txt

"postgres" "postgres-pass"

cat /etc/systemd/system/pgbouncer.service

[Unit]

Description=pgBouncer connection pooling for PostgreSQL

After=syslog.target network.target

[Service]

Type=forking

User=postgres

Group=postgres

PermissionsStartOnly=true

ExecStartPre=-/bin/mkdir -p /var/run/pgbouncer /var/log/pgbouncer

ExecStartPre=/bin/chown -R postgres:postgres /var/run/pgbouncer /var/log/pgbouncer

ExecStart=/usr/bin/pgbouncer -d /etc/pgbouncer/pgbouncer.ini

ExecReload=/bin/kill -SIGHUP $MAINPID

PIDFile=/var/run/pgbouncer/pgbouncer.pid

LimitNOFILE=100000

[Install]

WantedBy=multi-user.target