I have two PG12 servers and they are in a Master-Slave relationship (
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. (
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?