Christian Lehnert — Linux, Hacking & Faith
popular tags: #linux #psychology #faith #selfhosted #homelab #tip-of-the-week
// tip of the week 2026-09-28
PostgreSQL PITR - Point-in-Time Recovery With WAL Archiving

A nightly pg_dump at 4am means that when prod dies at 3pm you lose eleven hours of data, and there is nothing you can do about it. Postgres already writes down every change as it happens in the WAL. Archive that continuously on top of a base backup and you can recover to any second, including the moment right before someone ran the bad command. That is PITR, and it is the difference between an outage and a catastrophe. With the two numbers, RPO and RTO, that should drive the whole decision.

read tip → all tips
2026-10-17 NetBird Part 4 - Reaching the Things That Cannot Run the Agent
2026-10-14 Secrets in Git, Done Right
2026-10-10 Terraform or OpenTofu
2026-10-06 NetBird Part 3 - Access Policies, or RBAC for Your Network
2026-10-03 Azure Managed Identities
2026-09-29 Where Should Agent Code Run
2026-09-28 TIP PostgreSQL PITR - Point-in-Time Recovery With WAL Archiving
2026-09-26 Patching - The Boring Control That Stops Most Breaches, and Why It Still Does Not Happen
2026-09-24 If a Human Can Delete Prod, That Is the System's Fault, Not the Human's
1/7 older >