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...