<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
Nope, just one host. I mean how would MapServer know which to choose? Does it work referencing just one proxy?
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> mapserver-users <mapserver-users-bounces@lists.osgeo.org> on behalf of Linsenmaier Dierk <Dierk.Linsenmaier@regiodata-gmbh.de><br>
<b>Sent:</b> Monday, March 18, 2019 5:10:50 AM<br>
<b>To:</b> mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> [mapserver-users] mapserver connection string with multiple hosts</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hello altogether,<br>
<br>
we are running a postgresql cluster with patroni and haproxy.<br>
<br>
Therefore we'd like to address mutliple postgresql servers via haproxy in one connection string.<br>
Haproxy then decides which postgresql servers is master and has to be addressed.<br>
<br>
Is it possible to address multiple hosts in one connection string in a layer file?<br>
<br>
For examle something like this:<br>
CONNECTION "host=haproxy01,haproxy02,haproxy03 dbname=mydb user=myuser password=mypass port=5000"<br>
<br>
Thanks and cheers,<br>
Dierk<br>
-- <br>
<br>
Dierk Linsenmaier<br>
Systemtechnik<br>
<br>
regioDATA<br>
Tullastr. 61<br>
79108 Freiburg i. Brsg.<br>
Telefon 07621 91943-477<br>
Telefax 07621 91943-465<br>
dierk.linsenmaier@regiodata-gmbh.de<br>
<a href="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">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</a><br>
<br>
regioDATA Gesellschaft für raumbezogene Informationssysteme mbH<br>
Sitz Lörrach, Amtsgericht Freiburg HRB 412719<br>
Geschäftsführer: Michael Schade<br>
_______________________________________________<br>
mapserver-users mailing list<br>
mapserver-users@lists.osgeo.org<br>
<a href="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">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</a></div>
</span></font></div>
</body>
</html>