PostgreSQL Point-in-Time Recovery with pgBackRest and Patroni: WAL, Timelines, Failures, and Recovery Verification

Point-in-time recovery (PITR) is one of the PostgreSQL recovery techniques I wanted to understand beyond the documentation and theory. For this exercise, I used a local three-node PostgreSQL 16 enviro