Backup

Monitor PostgreSQL WAL Archiver Status with pg_stat_archiver pg_stat_archiver is the canonical place to check whether PostgreSQL's continuous archiving is keeping up — a single-row view that exposes last_archived_wal, last_failed_wal, and the rolling failure count without parsing log files. On a healthy cluster the row …

PostgreSQL Physical Backups with pg_basebackup pg_basebackup takes a physical, binary-level snapshot of a running PostgreSQL cluster. Unlike pg_dump, which produces a logical export of one database at a time, pg_basebackup captures the entire data directory — all databases, configuration files, and enough WAL to make …

Backing Up Your Remote PostgreSQL Database: A Step-by-Step Guide with pg_dump In the world of databases, regular backups are crucial for ensuring data safety and minimizing downtime during unforeseen circumstances. This post dives into using pg_dump, a powerful PostgreSQL utility, to create a compressed archive of your …