Category: PostgreSQL

Posted on

PostgreSQL Tools List: The Essential Stack for Production DBAs

river in green valley

TL;DR: PostgreSQL doesn’t ship with a built-in monitoring suite, backup manager, or HA framework — you assemble the stack yourself from specialised tools.
That’s not a weakness: it means you pick what fits your environment instead of paying for features you don’t use.
This list covers one best-in-class pick per category, with brief notes on when to use the alternatives.
Six categories are non-negotiable in production: HA/failover, backup and PITR, connection pooling, monitoring, query analysis, and log analysis.
Everything else is optional.

Continue reading “PostgreSQL Tools List: The Essential Stack for Production DBAs”
Posted on

PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived

serene snowy mountain landscape with pines

PostgreSQL has a mature, production-grade high availability stack that costs nothing in licensing and is straightforward to operate once it is set up.

This lab builds a six-node HA cluster using four open-source components: Patroni for cluster management and automatic failover, etcd as the distributed consensus store, HAProxy for load balancing and connection routing, and keepalived for a floating virtual IP that survives HAProxy node failures.

The result is a cluster where a primary failure is detected and a new primary is elected in under 30 seconds, with no manual intervention required.

Continue reading “PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived”