Hot-Standby Disaster Recovery for 50 TB PostgreSQL with Patroni, S3 WAL-E & Route 53 Failover <2 min
Sep 26, 2025 - Senior
$2,800.00 Fixed
Crisis Scenario:
You run a 50 TB PostgreSQL 14 cluster on bare-metal in London. Last fiber cut gave 7 h outage and $2 M lost bookings. Board now mandates hot-standby DR site in Frankfurt with automatic failover <2 min and zero data loss.
Senior Solution Deliverables:
- Patroni 3-node cluster ( London leader, Frankfurt sync standby, Frankfurt async ).
- Continuous WAL archiving to S3 Glacier via WAL-E ( 30-day retention ).
- Route 53 health-check + Patroni REST API → DNS flip in <90 s.
- Chaos test : iptables DROP on primary → measured failover 1 min 47 s.
- France
- Proposal: 0
- Verified
- Less than a month
Jean Dupont
Île-de-France , France
Member since
Oct 26, 2024
Total Job
5
Last seen