3 ms·
I like RDS for the same reason, but I wonder if there's a way you could run Postgres locally, as you suggest, while still using RDS for all the replication/back
by petercooper 6y ago
I like RDS for the same reason, but I wonder if there's a way you could run Postgres locally, as you suggest, while still using RDS for all the replication/backup side of things? That way the local Postgres management could be pretty minimal and outsource the "annoying bits" to RDS as before. I need to look into the best way to set up something like that.. perhaps pgPool-II.
- pbowyer 6y agoWould this cope with needing to replicate the web server onto another machine as well, for cloud-level reliability? Rather than web + local db <-----> rds you end up with web + local db <-\ |--> rds web + local db <-/ At which point the two masters plus a RDS slave is something I don't know if it's feasible.