I have two PG12 servers and they are in a Master-Slave relationship (replication).
What I want to do is have a virtual ip and link it to the master DB server being replicated to the slave one. I want the slave DB server to promote to master when the formal master dies. (failover)
I am trying to use HAProxy but have no idea. Examples from Google have other applications involved. I tried to use repmgr but I keep getting error during installation. (FATAL: no pg_hba.conf entry for host "__IP__", user "__USER__", database "__DB__", SSL off)
Can anyone please give me an advice or guide me with an example?
