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.
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.
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...
Sebastiaan Mannem · August 19, 2019
Database connection poolers are useful tools that enable organizations to deliver high-performing applications by efficiently utilizing Postgres...
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...
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.
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...
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...
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.
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...
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...
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...
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.
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.
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
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.
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
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...
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...
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.
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...
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...
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...
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.
- Developer Resources
- High Availability
- Replication and Failover
- Performance Tuning
- Performance Monitoring and Alerting
- Containers, Kubernetes, Docker
- Oracle To Postgres Migration
- DBA and Admin Resources
- Tools and Extensions
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.
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 organizationsDownload Now