[mapserver-users] mapserver connection string with multiple hosts

[Linsenmaier Dierk]

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
www.regiodata-gmbh.de

regioDATA Gesellschaft für raumbezogene Informationssysteme mbH
Sitz Lörrach, Amtsgericht Freiburg HRB 412719
Geschäftsführer: Michael Schade