cloudnewbie

My use will be for a small SaaS. Having automated failover for the database would make me feel much more at ease about uptime and reliability for clients.

RDS is on my list. It seems like the easiest, most hands-off solution, but has a price premium compared to running my own pg on EC2 or similar.

Minimizing unintended downtime is the primary intent. Having a second server automatically take over in less than a minute or two would be good enough for me. I'll look in to shared disks and Patroni. Thank you for the pgconf video too.