PgBouncer

PgBouncer is an open-source, lightweight, single-binary connection pooler for PostgreSQL. It can pool connections to one or more databases (on possibly different servers) and serve clients over TCP and Unix domain sockets.

Prerequisites

1. Create a user in the PgBouncer /etc/pgbouncer/pgbouncer.ini file:

stats_users = <Username>

2. Add an associated password for user in the PgBouncer /etc/pgbouncer/userlist.txt file:

"<Username>" "<PASSWORD>"

3. Uncomment the ignore_startup_parameters = extra_float_digits option in the file /etc/pgbouncer/pgbouncer.ini such that the connection to pgpooler instance with many modern PostgreSQL clients does not fail.

4. For Virtual machines, install the Linux agent.

Configuring the credentials

Configure the credentials in the directory /opt/opsramp/agent/conf/app.d/creds.yaml

pgbouncer:
- name: pgbouncer
  user: <username>
  pwd: <Password>
  encoding-type: plain
  labels:
    key1: val1
    key2: val2
  

Configuring the application

Virtual machine

Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-detection.yaml

- name: pgbouncer
  instance-checks:
    service-check:
      - pgbouncer
    process-check:
      - pgbouncer
    port-check:
      - 6432
  

Docker environment

Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-container-detection.yaml

- name: pgbouncer
  container-checks:
    image-check:
      - pgbouncer
    port-check:
      - 6432
  

Kubernetes environment

Configure the application in config.yaml

- name: pgbouncer
  container-checks:
    image-check:
      - pgbouncer
    port-check:
      - 6432
  

Validate

Go to Resources under the Infrastructure tab to check if your resources are onboarded and the metrics are collected.

Metrics