[mapserver-users] mapserver connection string with multiple hosts

[Lime, Steve D (MNIT)]

Nope, just one host. I mean how would MapServer know which to choose? Does it work referencing just one proxy?
________________________________
From: mapserver-users <mapserver-users-bounces at lists.osgeo.org> on behalf of Linsenmaier Dierk <Dierk.Linsenmaier at regiodata-gmbh.de>
Sent: Monday, March 18, 2019 5:10:50 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] mapserver connection string with multiple hosts

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
dierk.linsenmaier at regiodata-gmbh.de
https://gcc01.safelinks.protection.outlook.com/?url=www.regiodata-gmbh.de&data=02%7C01%7Csteve.lime%40state.mn.us%7C961eacd21f2a4f7f425608d6ab8b195f%7Ceb14b04624c445198f26b89c2159828c%7C0%7C0%7C636885011272670266&sdata=CZ7NLY88oNEPIuO6MwvMxDw2ZKPxTVAQSi4SytMu%2BsQ%3D&reserved=0

regioDATA Gesellschaft für raumbezogene Informationssysteme mbH
Sitz Lörrach, Amtsgericht Freiburg HRB 412719
Geschäftsführer: Michael Schade
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fmapserver-users&data=02%7C01%7Csteve.lime%40state.mn.us%7C961eacd21f2a4f7f425608d6ab8b195f%7Ceb14b04624c445198f26b89c2159828c%7C0%7C0%7C636885011272670266&sdata=4vcFt7wYvmCJogqfte3Aw%2Fo3pdJv0mrYVXmMdp8qw1o%3D&reserved=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20190318/14189943/attachment.htm>