What is the role of PgBouncer in a Postgres High Availability stack?

Streaming replicas—and by extension, base backups—can become dangerously broken when the source and target machines run slightly different versions of glibc.

PostgreSQL is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 343 monitored systems.
We thus declare PostgreSQL as the DBMS of the Year 2018.

In April the Guardian switched off the Mongo DB cluster used to store our content after completing a migration to PostgreSQL on Amazon RDS. This post covers why and how

Pub/Sub, Triggers, FDW, JSONB, Extensions,...