Connection pooling using PgBouncer

To limit connections between the PEM agent and server on non-Windows systems, you can implement PgBouncer as a connection pooler. The process involves three main phases:

• ** Preparing the PEM database server **

It provides the steps to prepare the PEM database server to use with PgBouncer.

• ** Configuring PgBouncer **

It provides detailed information about configuring PgBouncer to allow it to work with the PEM database server.

• ** Configuring the PEM agent **

It provides detailed information about configuring a PEM agent to connect to PgBouncer.

For detailed information about using the PEM web interface, see Accessing the web interface .

• Preparing the PEM database server
  • Prerequisites
  • Creating users and roles for PgBouncer-PEM connections
  • Updating the configuration files to allow PgBouncer-PEM connections
  • Creating the SSL key and certificate for PgBouncer-PEM authentication
• Configuring PgBouncer
  • Prerequisites
    • EDB PgBouncer and PgBouncer installation considerations
  • Configuring PgBouncer
• Configuring the PEM agent
  • Prerequisites
  • Configuring a new PEM agent
  • Configuring an existing PEM agent