There are good and solid HA options in the Postgres ecosystem that are fully open. You can use Patroni for standard Postgres or YugabyteDB that is fault-tolerant by design.

Specifics are here: https://www.yugabyte.com/postgresql/postgresql-high-availabi...