Skip to content
Announcing BigAnimal: Fully managed PostgreSQL in the Cloud
Contact usDocsPlans

Using tools such as pgPool and PgBouncer to extend PostgreSQL capabilities

PostgreSQL being a community driven database has hundreds of extensions to extend the capabilities of PostgreSQL. Extensions in PostgreSQL can help bridge many gaps in functionality and adhere to many use cases such as high availability, sharding, migration, geolocation, connection pooling, making monogenous and heterogeneous connections with other databases such as MySQL, Oracle, and MongoDB.

pgbouncer auth_query and auth_user pro tips

Richard Yen11/6/2019

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep resource usage under control. PgBouncer is one such tool, and it’s great because it’s lightweight and yet ...

PgBouncer Tutorial: Installing, configuring and testing persistent PostgreSQL connection pooling

Philip Hankinson10/22/2019

Connection pooling is a big deal in Postgres. Connections to the database can take a relatively large amount of overhead, especially if there are a lot of them, and here at EDB Professional Services we often recommend an open-source tool called PgBou ...

Pgpool vs PGBouncer

Sebastiaan Mannem8/19/2019

Database connection poolers are useful tools that enable organizations to deliver high-performing applications by efficiently utilizing Postgres. Implementing a high-quality connection pooler is a frequent request of clients using Postgres, and while ...

PgBouncer Pro Tip: Use auth_user

EDB Team12/18/2018

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep resource usage under control. PgBouncer is one such tool, and it’s great because it’s lightweight and yet ...

Quickstart guide on using pgPool

Timothy Steward6/4/2017

This guide is intended to get you up and started with a default installation of pgPool in front of a master and streaming replica. There is much more to pgPool that is not covered in this quickstart, the intent here is only to get you a simple config ...

Getting Started with PostGIS

Adam Wright10/27/2015

Released nearly 15 years ago, PostGIS is an open source extension to Postgres that spatially enables your database server, and follows the OGC Simple Features for SQL specification. If you are coming from another standards based spatial database you ...

“Sorry, too many clients already” - How to Use PgPool to Solve Database Connection Load Problems

Piyush Sharma4/16/2020

  With the ongoing crisis of COVID-19, I keep myself updated with the latest situation around the globe. The WHO’s website is one I’ve used frequently—and even there I began to intermittently see the error message “sorry, too many clients already“ in ...

Can PgBouncer survive transient network events?

Philip Hankinson2/14/2020

This is the final part of my technical responses to a series of questions about the use of PgBouncer. To read the other posts in the series, use the links below. 

Can PgBouncer session survive everything we throw at it?

Philip Hankinson2/6/2020

  This is part four of my technical response to a series of questions about the use of PgBouncer and what you need to look out for. To read the other posts in the series, use the links below.  Part 1: Installing, configuring and testing persistent Po ...

Can PgBouncer handle failover to a new machine?

Philip Hankinson12/17/2019

  Part Three: PgBouncer and persistent connections during downtime (This is part three of my technical response to a series of questions about the use of PgBouncer and what you need to look out for. Part two can be found here) So, now we have success ...

PgBouncer Connection Pooling: What to do when persistent connectivity is lost

Philip Hankinson11/13/2019

  (This is part two of my technical response to a series of questions about the use of pgbouncer and what you need to look out for.  Part one can be found here) So, in Part One of this blog we completed the installation of PgBouncer, configuration an ...

PgBouncer Logs Rotation in Linux and Windows Tutorial

Raghavendra Rao11/7/2019

Before doing a deep dive into the subject, a short outline about PgBouncer, it is a lightweight connection pooler for PostgreSQL that dramatically reduces the processing time and resources for maintaining a large number of client connections to one o ...

How to use pg_dump and pg_restore in multi-host enviorment

Bruce Momjian11/7/2019

You have probably looked at logical dumps as supported by pg_dump and restores by pg_restore or, more simply, psql. What you might not have realized are the many options for dumping and restoring when multiple computers are involved.

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

Vishal Sawale2/22/2019

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 th ...

EDB's Recommendation for Pgpool II Usage

Ahsan Hadi5/23/2018

he Pgpool II Community releases a major version every year and minor versions several times in a year. In the last few releases, a lot of emphasis and focus was given to improving the existing functionality of pgpool II, making it more stable, robust ...

Using auth_method=hba in PgBouncer

Richard Yen8/18/2017

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 improvements have been implemented, including the ability to use aut ...

A Real Integration: EFM and PgPool

Raghavendra Rao1/4/2019

In this article we are going to see how database servers work together to allow the second server to take over quickly if the primary server fails(high availability), and to allow multiple servers to serve the same data for SELECTs(horizontal read sc ...

Autoprewarm: A New Functionality in pg_prewarm

EDB Team9/25/2018

Autoprewarm In PostgreSQL 11, a new functionality of autoprewarm has been added into the contrib module pg_prewarm.  This automatically warms the shared buffers with the same pages held before the last server restart. To accomplish this, Postgres now ...

Pgpool Support Metrics for EPAS Database

Ahsan Hadi4/30/2018

One question that comes up very often is which version of Pgpool II is supported with which database server? I would like to address this question in this post.

Pgpool-II Keeps Pace With Demands of Today’s Architectures and Workloads

EDB Team3/30/2017

Middleware can have a significant impact on the operation and performance of the database system. Pgpool-II  is the middleware product that sits between the PostgreSQL server and database clients and is developed and maintained by a committed open so ...

Pgpool-II Enables Horizontal Scalability in Postgres

EDB Team11/4/2014

This blog was co-written by Ahsan Hadi. The idea of ‘horizontal scalability’ was discussed in great detail at PGCon 2014 in Ottawa this year. It is great to see the community discussing ideas on how PostgreSQL can incorporate horizontally scalable fe ...

Best of Both Worlds: Integrating Pgpool with EDB Postgres Failover Manager

Vibhor Kumar1/23/2018

EDB Postgres Failover Manager (EFM) is a high availability module from EnterpriseDB (EDB) that monitors the health of Postgres clusters and verifies failures quickly. Should one occur, EFM can automatically promote a Standby node to Master to ensure ...

The pg_rewind Improvements in PostgreSQL 9.6

Vibhor Kumar1/11/2017

The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can be reattached to the new master as a standby without restoring it from the new base backup. The tool ...