[mapserver-users] mapserver connection string with multiple hosts

[Stephen Woodbridge]

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