Vizlib Home Try Vizlib
Welcome
Login

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

Login to post a comment