4 ms·
> I find it difficult to setup PostgreSQL without having a single point of failure and introducing downtime for things such as upgrades. Amazon does this with
by briandilley 7y ago
> I find it difficult to setup PostgreSQL without having a single point of failure and introducing downtime for things such as upgrades.
Amazon does this with RDS, and so can you.
This really isn't very tough to achieve with replicas. And for upgrades you just add a new replica with the latest version and promote it to master and replace the remaining nodes one at a time.
- skj 7y agoMan I love technical advice that has the word "just" in it. It's so simple!
- shawabawa3 7y agoRDS absolutely has downtime for upgrades, and even for master switchover