PgBouncer Archives - 2ndQuadrant

Posts

Running multiple PgBouncer instances with systemd

August 13, 2020/0 Comments/in Eisentraut's PlanetPostgreSQL /by Peter Eisentraut

Since PgBouncer runs as a single process, it is not straightforward to make use of multiple CPUs on a host. When you are running on real hardware, this is wasteful, since single-CPU server machines don’t exist anymore, as far as I can tell. When using virtualization, you could just provision a single CPU per virtual […]

Understanding user management in PgBouncer

June 15, 2020/0 Comments/in Eisentraut's PlanetPostgreSQL /by Peter Eisentraut

PgBouncer is a popular connection proxy and pooler for PostgreSQL. As PgBouncer presents a PostgreSQL protocol interface to client applications, it also handles client authentication. For that, it maintains its own directory of users and passwords. That is sometimes a source of confusion, so in this blog post I want to try to describe how […]

PG Phriday: PgBouncer or Bust

January 11, 2019/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

What is the role of PgBouncer in a Postgres High Availability stack? What even is PgBouncer at the end of the day? Is it a glorified traffic cop, or an integral component critical to the long-term survival of a Postgres deployment? When we talk about Postgres High Availability, a lot of terms might spring to […]

PG Phriday: Securing PgBouncer

April 20, 2018/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

We all love PgBouncer. It’s a great way to multiplex tens, hundreds, or even thousands of client connections to a small handful of Postgres sessions. What isn’t necessarily so endearing, is that it can’t pass authentication from itself to Postgres, as each Postgres session may exist before the connection to PgBouncer is established. Or can […]

PG Phriday: Getting RAD with Docker [Part 4]

December 8, 2017/5 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

PgBouncer is a popular proxy and pooling layer for Postgres. It’s extremely common to reconfigure PgBouncer with repmgr so it always directs connections to the current primary node. It just so happens our emerging Docker stack could use such a component. In our last article, we combined Postgres with repmgr to build a Docker container […]

PgBouncer 1.7 – “Colors Vary After Resurrection”

February 3, 2016/7 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

PgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.7 was announced on the 18th of December 2015. In this blog post we’ll talk about the major new improvements in PgBouncer.

What’s New in PgBouncer 1.6

August 23, 2015/7 Comments/in Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

PgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.6 was announced on the 1st of August 2015. In this blog post we’ll talk about the major new improvements in PgBouncer.

Posts

Running multiple PgBouncer instances with systemd

Understanding user management in PgBouncer

PG Phriday: PgBouncer or Bust

PG Phriday: Securing PgBouncer

PG Phriday: Getting RAD with Docker [Part 4]

PgBouncer 1.7 – “Colors Vary After Resurrection”

What’s New in PgBouncer 1.6

Support & Services

Products

Postgres Learning Center

About Us