Connection pooling using PgBouncer

You can use PgBouncer as a connection pooler for limiting the number of connections from the PEM agent to the Postgres Enterprise Manager (PEM) server on non-Windows machines:

• PEM server and agent connection management mechanism is an introduction to the PgBouncer-PEM infrastructure.

• Preparing the PEM database server provides information about preparing the PEM database server to use with PgBouncer.

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

• Configuring the PEM agent 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 .

• PEM server and agent connection management mechanism
  • Without PgBouncer
  • With PgBouncer
• 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