Category: PostgreSQL

Posted on

PostgreSQL 18 Backup & Recovery Lab on Ubuntu 24.04 — pg_dump, pg_basebackup and pgBackRest

red and blue abstract painting

If you work with PostgreSQL in production, backups are not optional.

In this lab, I built a complete PostgreSQL 18 backup and recovery environment on Ubuntu 24.04 and tested all three major backup approaches:

  • logical backups with pg_dump
  • physical backups with pg_basebackup
  • production-grade backups with pgBackRest, including WAL archiving and Point-In-Time Recovery (PITR)

Everything was tested on a real VM with actual recovery drills — not simulations.

Continue reading “PostgreSQL 18 Backup & Recovery Lab on Ubuntu 24.04 — pg_dump, pg_basebackup and pgBackRest”
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”