Install RBT: PgBouncer

PgBouncer provides a lightweight PostgreSQL connection pool for RBT. It reduces database connection overhead and keeps application services from opening more direct PostgreSQL sessions than the deployment requires.

This page is one step in the complete RBT installation guide.

Before you start

• Install and test PostgreSQL first.
• Review the RBT PgBouncer configuration before replacing the system directory.
• Keep a recoverable copy of any existing PgBouncer configuration.

Expected result

The PgBouncer package should use the configuration shipped with RBT and the service should start without configuration errors.

Verify this step

test -L /etc/pgbouncer && readlink -f /etc/pgbouncer
systemctl is-active pgbouncer

Install PgBouncer

1. Install

apt install -y pgbouncer

1. Copy pgbouncer config

rm -rf /etc/pgbouncer
ln -sf /opt/rbt/install/pgbouncer /etc/pgbouncer

Next