Comment by faangguyindia

try setting up replication/failover in postgres, it's much more work.