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 Windows private agents version 11.58 and later, the default PgBouncer port is 6434. Upgrading a private agent does not change its existing PgBouncer port. Linux private agents always use the default port 6432, on both clean installations and upgrades.

Troubleshooting

For related troubleshooting, see the following in the private agent troubleshooting guide:

• Linux: Antivirus removes PgBouncer, agent fails to authenticate to the bundled database

• TranDb connection failures