Typically, this is handled via a load balancer where the connection is
pointed at a proxy and the proxy is configured with a list of hosts, not
via the connection string, and then decides which host to forward the
connection to.
-Steve W
On 3/18/2019 6:10 AM, Linsenmaier Dierk wrote:
Hello altogether,
we are running a postgresql cluster with patroni and haproxy.
Therefore we'd like to address mutliple postgresql servers via haproxy in one
connection string.
Haproxy then decides which postgresql servers is master and has to be addressed.
Is it possible to address multiple hosts in one connection string in a layer
file?
For examle something like this:
CONNECTION "host=haproxy01,haproxy02,haproxy03 dbname=mydb user=myuser
password=mypass port=5000"
Thanks and cheers,
Dierk
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
