Postgres and data

PostgreSQL and SQLite on a small server: WAL archiving, point-in-time recovery, dumps versus physical backups.

Postgres and data · 12 min read

Restore PostgreSQL to a timestamp with recovery_target_time

Step by step PITR on PostgreSQL 15 to 17 with recovery.signal, restore_command and recovery_target_time, plus timelines and how to verify the result.

Postgres and data · 11 min read

PostgreSQL WAL archiving from scratch on a single Debian VPS

Turn on archive_mode, write a safe archive_command, take a pg_basebackup, and prove with pg_stat_archiver that WAL really reaches the archive.

Postgres and data · 10 min read

How much data a disk failure costs with WAL archiving

We killed a PostgreSQL server mid-write and restored from the archive alone, so you can choose archive_timeout from measured loss instead of guessing.

Postgres and data · 10 min read

pg_dump vs physical backup vs PITR: which to use

A decision guide to logical dumps, pg_basebackup and point-in-time recovery, with a comparison table and recommendations by database size and RPO.