We have our AWX running in K8s and postgres is configured externally on a Patroni HA.
Had enabled “pg_hostname=postgresql” and its connectivity to primary server
How can we give primary and secondary DB server in the connection string.
Typically you will use something that will act as a proxy or load balancer between the two servers so that all you need to do is fail over the load balancer and not reconfigure AWX.
Do we have the option of connection string like ’ pg_state=read-write ’ in AWX , so that we can give both primary and secondary server and the connection will go to db which is having read write option.