HA postgres and offsite backup

1

I’ve got a postgres-flex cluster of 3 in one region. I’d like a read replica (or 3?) of the database in a different region (possibly for failover if my primary region went down but also for a near-live offsite backup if my primary machines somehow got deleted or the primary data center was destroyed by fire or whatever).

What’s the recommended strategy for this?

Does replication only happen within a single region?

Thanks.

2

I’m reading up fly’s support for Barman. Perhaps that is good enough for me but would it be bad if I created it in a different region than my primary so have off-site backup? I would chose a region that is close to the primary but different none-the-less. Is this problematic?

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.