mapserver connection string with multiple hosts

Linsenmaier Dierk <[email protected]>
Newsgroups gmane.comp.gis.mapserver.user
Message-ID <[email protected]>
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
-- 

Dierk Linsenmaier
Systemtechnik

regioDATA
Tullastr. 61
79108 Freiburg i. Brsg.
Telefon  07621 91943-477
Telefax   07621 91943-465
[email protected]
www.regiodata-gmbh.de

regioDATA Gesellschaft für raumbezogene Informationssysteme mbH
Sitz Lörrach, Amtsgericht Freiburg HRB 412719
Geschäftsführer: Michael Schade
_______________________________________________
mapserver-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.