Nope, just one host. I mean how would MapServer know which to choose? Does it work referencing just one proxy? ________________________________ From: mapserver-users <[email protected]> on behalf of Linsenmaier Dierk <[email protected]> Sent: Monday, March 18, 2019 5:10:50 AM To: [email protected] 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 [email protected] 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 [email protected] 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
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
