Pgpool2 won't connect after you fix a hostname? Delete the pgpool_status file—it caches host status across restarts and won't update automatically.

Dive into PostgreSQL replication strategies with slides from PerconaLive 2018, covering practical approaches to keeping your databases in sync.

Set wal_level to logical and enable wal_log_hints to unlock logical replication and pg_rewind without restarting your cluster.

Stop guessing what's slow in PostgreSQL—configure logging to actually see it.

Default `archive_mode = off` means `archive_command` is ignored—set both now to avoid a restart later when you need WAL archiving.

Enable wal_compression to shrink write-ahead logs and replica replication traffic after checkpoints. The CPU cost is minimal for nearly all workloads.

PostgreSQL databases live in directories, and naming them wisely saves you headaches during major version upgrades.

Slides from "Why PostgreSQL is Terrible" talk at Nordic PGDay are online. Discover what makes PostgreSQL unexpectedly great through its apparent flaws.

PostgreSQL replication overwhelms with options?

When a network disconnect interrupts your COMMIT, did the transaction really go through?