cloudnewbie

Re:Ask HN: Best Tools for High Availability PostgreSQL? on Friday November 01, 2024 @11:14PM (#42023796)

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.

Re:Ask HN: Best Tools for High Availability PostgreSQL? on Friday November 01, 2024 @11:06PM (#42023772)

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.

Re:Ask HN: Best Tools for High Availability PostgreSQL? on Friday November 01, 2024 @11:03PM (#42023761)

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.

Ask HN: Best Tools for High Availability PostgreSQL?

Posted by cloudnewbie on Thursday October 31, 2024 @09:58AM
from the ask-hn dept.

PostgreSQL has lots of different tools available for replication, though in various states of support and maintenance. What are your current recommendations for a small-scale Postgres cluster (e.g. 3 node on modest VMs)?My use case is a relatively standard web app with database backend. One write master is fine, but it should have automatic failover if the primary is unavailable. As a solo...

( Read More... | 8 comments | 2 points | on HN )