Vizlib Server - multiple postgres server (failing over servers) on one integration
Hello,
Actually I can add an integration for one PostgreSQL server with the connection URL and the enable SSL function. The connection URL has this format:
postgresql://username@postgres1.domain.com:5432/databasename
The integration is working fine.
Now I have one main PostgreSQL server and 2 backup server if the main one is failing. So I want to add the other servers in my connection URL. I tried it like that:
postgresql://username@postgres1.domain.com:5432,postgres2.domain.com:5432,postgres3.domain.com:5432/databasename.
This URL is not working and I got confirmation from the support, that this is at the moment not implemented and foreseen.
Therefore I would like to raise this feature request, to be able to add in the integration a failing over Principe if one of the DBs are failing down, the connection URL is able to switch too a backup machine which is working.
Thank you in advance.
KInd regards,
Chris