Came to say the same thing. Personally I'd only touch Postgres in a couple cases.

1. Downtime doesn't matter. 2. Paying someone else (eg. AWS) to manage redundancy and fail-over.

It just feels crazy to me that Postgres still doesn't have a native HA story since I last battled with this well over a decade ago.