PgBouncer on Jitterbit private agents

Introduction

PgBouncer is a lightweight connection pooler for PostgreSQL. It is used to manage and pool database connections, reducing the overhead of repeatedly opening and closing connections. This improves performance and allows private agents to handle a larger number of concurrent operations. PgBouncer is bundled with and runs on Windows, Linux, and Docker private agents.

Configuration

Configuration is stored in the pgbouncer.ini file (/opt/jitterbit/pgbouncer/share/doc/pgbouncer on Linux, and C:\Program Files\Jitterbit Agent\pgbouncer on Windows).

Ports

For clean installations of private agents versions 11.58 and later, the default PgBouncer port is 6434. When installing or upgrading from older versions, the default port is 6432.