PostgreSQL
5 articles tagged PostgreSQL.
Fix PostgreSQL 'sorry, too many clients already' with Limits and Pooling
Find what is holding PostgreSQL connections, free slots safely, cap roles and databases, add PgBouncer pooling and size max_connections, including Azure Database for PostgreSQL.
PostgreSQL Autovacuum Tuning: Fix Table Bloat and XID Wraparound Risk
Measure bloat and transaction ID age, remove what blocks vacuum, and tune autovacuum thresholds, cost limits and per-table settings so large, busy PostgreSQL tables stay healthy.
PostgreSQL Backups with pgBackRest: Full, Differential and PITR Restore
Set up pgBackRest for PostgreSQL on Linux: WAL archiving, encrypted repositories, full and differential schedules, retention, an Azure Blob copy, and point-in-time recovery you have actually tested.
PostgreSQL Logical Replication: Set Up, Monitor and Fix Slot Errors
Configure PostgreSQL logical replication with publications and subscriptions, monitor slots and apply workers, and resolve conflicts, WAL build-up and invalidated slots.
PostgreSQL High Availability: A Production Manual for Patroni, etcd v3, HAProxy and PgBouncer
How to build a PostgreSQL HA cluster with automatic failover and synchronous replication using Patroni, an etcd DCS, HAProxy health-check routing and PgBouncer connection pooling.