If use these tools can make a great modern database cluster with full features:
- pgbouncer (with HAProxy for HA)
The main database will run on the repmgr servers. It has primary and standby. If primary down, standby can up. But will take some seconds. At that time, user can't access the database by pending? Isn't there has a good way to make realtime response?