What's the self-hosted Postgres HA story these days?

pg_auto_failover makes it an absolute breeze. I cannot understand how it's not mentioned in the article.

I've been runnning it for over 3 years with great success, and 0 downtime. Not to mention the extreme price difference compared to managed solutions - https://github.com/hapostgres/pg_auto_failover/discussions/6...

How are major version upgrades handled on PGA these days? Last time I used it (it's amazing), there wasn't a great path forward for minimal-downtime major version upgrades.

Same.

But major upgrades are only available once a year.

zero downtime for three years - congrats !

What about BU/DR? Is walg still the best?

I hosted postgres with cnpg operator in kubernetes. It does everything automagically: backups, wal backups and high-availability. Can't say nothing bad about it, it just worked for me. My only issue is that it releases versions too fast, I'd prefer some more relaxed schedule, but that's probably just me.

On self-hosted you can use the same as what cloud vendors are doing. Patroni or pg_auto_failover to manage single-primary + replicas. Maybe Neon to run an Aurora-like. CitusData... Azure did a lot around to get elasticity. Not easy to do the same. YugabyteDB on Kubernetes can be a cloud-native self-hosted solution

Which cloud vendors are using PGAF?

YugabyteDB can be self-hosted.