News for hackers. Stuff that matters.

A comment on Why PostgreSQL High Availability Matters and How to Achieve It. Parent comment

Re:Why PostgreSQL High Availability Matters and How to Achie... by porsager on Wednesday June 14, 2023 @12:27PM (#36328342)
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...

[ Parent | on HN ]
Re:Why PostgreSQL High Availability Matters and How to Achie... by whitepoplar on Wednesday June 14, 2023 @12:31PM (#36328416)
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.
[ Parent | on HN ]
Re:Why PostgreSQL High Availability Matters and How to Achie... by paulddraper on Wednesday June 14, 2023 @12:54PM (#36328818)
Same.

But major upgrades are only available once a year.

[ Parent | on HN ]
Re:Why PostgreSQL High Availability Matters and How to Achie... by mistrial9 on Wednesday June 14, 2023 @12:32PM (#36328425)
zero downtime for three years - congrats !
[ Parent | on HN ]
Re:Why PostgreSQL High Availability Matters and How to Achie... by candiddevmike on Wednesday June 14, 2023 @12:47PM (#36328684)
What about BU/DR? Is walg still the best?
[ Parent | on HN ]