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 Yen · November 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 has a handful of nifty features for DBAs that have very specific needs.

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

Philip Hankinson · October 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...

Pgpool vs PGBouncer

Sebastiaan Mannem · August 19, 2019

Database connection poolers are useful tools that enable organizations to deliver high-performing applications by efficiently utilizing Postgres...

PgBouncer Pro Tip: Use auth_user

Richard Yen · December 18, 2018

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep...

Quickstart guide on using pgPool

Timothy Steward · June 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 configuration working as quickly as possible.

Getting Started with PostGIS

Adam Wright · October 26, 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...

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

Piyush Sharma · April 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...

Can PgBouncer survive transient network events?

Philip Hankinson · February 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 Hankinson · February 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...

Can PgBouncer handle failover to a new machine?

Philip Hankinson · December 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...

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

Philip Hankinson · November 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...

PgBouncer Logs Rotation in Linux and Windows Tutorial

Rhagavendra Rao · November 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 or more databases. Typically used to increase the number of user connections that can be handled in a high-performance environment. For more details on Installing/Configuring PgBouncer refer to the documentation.

How to use pg_dump and pg_restore in multi-host enviorment

Bruce Momjian · November 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 Sawale · February 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 three configuration steps

EDB's Recommendation for Pgpool II Usage

Ahsan Hadi · May 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 and able to handle complex real-world scenarios.

Using auth_method=hba in PgBouncer

Richard Yen · August 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 auth_type=hba, which implements a PG-like HBA authentication method similar to the pg_hba.conf format we're all used to

A Real Integration: EFM and PgPool

Raghavendra Rao · January 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...

Autoprewarm: A New Functionality in pg_prewarm

Mithun Chicklore Yogendra · September 25, 2018

Autoprewarm In PostgreSQL 11, a new functionality of autoprewarm has been added into the contrib module pg_prewarm. This automatically warms the...

Pgpool Support Metrics forEDB Postgres Advanced Server

Ahsan Hadi · April 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

ahsan hadi · March 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...

Pgpool-II Enables Horizontal Scalability in Postgres

Jason Davis · November 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...

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

Vibhor Kumar · January 23, 2018

EDB Postgres Failover Manager (EFM) is a high availability module from EnterpriseDB (EDB) that monitors the health of Postgres clusters and verifies...

The pg_rewind Improvements in PostgreSQL 9.6

Vibhor Kumar · January 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...

Get Postgres tips & tricks

Subscribe to our newsletter to get advanced Postgres how-tos.

Related Tutorials

Featured Webinar

EDB Failover Manager - Features and Demo

EDB Postgres Failover Manager (EFM) is a high-availability module from EnterpriseDB that enables a Postgres Master node to automatically failover to a Standby node in the event of a software or hardware failure on the Master.

Watch Now

Introducing Postgres Pulse Live

Free To Attend: Every other Monday 11AM ET

A biweekly blog and live video forum series built to offer insight into how we analyze problems and develop solutions using Postgres.

About Postgres Pulse Live

EDB Postgres Advanced Server

Oracle Compatible Postgres

EDB Postgres Replication Server (EPRS) integrates existing databases with EDB Postgres to make this data available for enterprise-wide analytics, increase OTLP and reporting performance, or in multi-master mode to offer solutions for geo-dispersed organizations

Download Now