Upcoming Webinar: Beyond Joins and Indexes: Explaining the Postgres Query Optimizer, Part 2 • Register Now

Get Started

Enter the terms you wish to search for.

How to Configure pgBouncer to use Postgres Enterprise Manager(PEM) Agent

January 23, 2023

This video provides detailed information about using pgBouncer as a connection pooler for limiting the number of connections from the PEM Agent towards the Postgres Enterprise Manager™ (PEM) server on non-Windows machine. The video is comprised of three configuration steps:

 

   1. Preparing the PEM Database Server.

   2. Configuring pgBouncer.

   3. Configuring the PEM Agent.

 

The video also takes user through the PEM server- PEM agent Connection Management Mechanism with or without connection pooler.

Share this

Relevant Blogs

Elephant

Surviving Without a Superuser: Coming to v16

EDB is proud to present the following excerpt from Surviving Without a Superuser from EDB VP, Chief Data Scientist Robert Haas' personal blog. You can read the entire article here...
January 30, 2023

Why you should use Docker Compose

SUMMARY: This article explains the benefits of using Docker Compose for creating multiple container applications. It reviews the steps for...
January 24, 2023

More Blogs

Quickstart guide on using pgPool

Steps (as root user)   #!/bin/bash   # Setup YUM repository for installing EPAS as the PEM # repository rpm -Uvh  http://yum.enterprisedb.com/edbrepos/edb-repo-9.6-4.noarch.rpm # Set YUM username/password in edb.repo export...
January 24, 2023

Using auth_method=hba in PgBouncer

Introduction PgBouncer is a great tool for improving database performance with connection pooling.  I've been using it for many years, since it first became available in 2007.  Since then, several...
January 23, 2023