Hacker News new | ask | show | jobs
by SergeAx 1687 days ago
> can comfortably be replaced by a single postgres primary

And lose all the data in a single failure?

1 comments

I said a single -primary- and explicitly mentioned having replicas.

I'm very confused why you might think that could "lose all the data" from a single one of those nodes failing.

I was reading your reply too quick, sorry. Anyway, even failover replication in PG is not there out of the box and have it's quirks.
I don't disagree at all with that statement although invetably what mongo does have out of the box definitely has its own quirks.

Getting operations right is tricky no matter what you're doing/using, and you always have to learn your backend's idiosyncracies no matter which one you choose.