PostgreSQL/PgBouncer

cat <<-'EXE'|sudo bash apt-get update;echo apt list -a --upgradable sudo apt-get install -y pgbouncer EXE

systemctl status pgbouncer.service sudo systemctl stop pgbouncer.service sudo systemctl start pgbouncer.service sudo systemctl restart pgbouncer.service

ls -lah /etc/pgbouncer/ sudo cat /etc/pgbouncer/userlist.txt sudo cat /etc/pgbouncer/pgbouncer.ini sudo cat /etc/pgbouncer/pgbouncer.ini|less

Configure

sudo rsync -avz /etc/pgbouncer/pgbouncer.ini /etc/pgbouncer/pgbouncer.ini.bkp
sudo rsync -avz /etc/pgbouncer/userlist.txt  /etc/pgbouncer/userlist.txt.bkp

Playground

ls -lah /etc/pgbouncer/ ls -lah /var/log/postgresql/ ls -lah /var/run/postgresql/

References

PostgreSQL » PgBouncer » Ubuntu PostgreSQL » PgBouncer » Config PostgreSQL » PgBouncer » Install PostgreSQL » PgBouncer PostgreSQL » Helm PostgreSQL
Academia JavaEE Workspace in Ubuntu IntelliJ IDEA OpenLDAP OpenVPN MariaDB HAProxy Helm CIDR UFW K8s	K8s » Swiss Knife K8s » Ingress K8s » Service K8s » Run