Re: mapserver connection string with multiple hosts
Stephen Woodbridge <[email protected]>
| Newsgroups | gmane.comp.gis.mapserver.user |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users