Physical base backup vs logical dump for 4‑hour RTO on 500 GB Rails/PostgreSQL
Goal Select a restoration strategy that meets a 4‑hour RTO for a 500 GB PostgreSQL database plus 200 GB of ActiveStorage attachments in a Rails 7.x application. Constraints & uncertainty Physical base backup (pg_basebackup + PITR) restores the data directory in ~45 minutes but demands identical PostgreSQL major version, OS architecture, and pg_control co
rails