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:

• :ref:`PEM server and agent connection management mechanism <PEM server and agent connection management mechanism>`  is an introduction to the PgBouncer-PEM infrastructure.
  

• :ref:`Preparing the PEM database server <Preparing the PEM database server>`  provides information about preparing the PEM database server to use with PgBouncer.
  

• :ref:`Configuring PgBouncer <Configuring PgBouncer>`  provides detailed information about configuring PgBouncer to allow it to work with the PEM database server.
  

• :ref:`Configuring the PEM agent <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