I have an application currently running on sql server i want to move it on postgressql server can any one please suggest me any tool support following type of scenario,
i have one master and one slave database if the any way master is crashed then application automatically connect to slave for further operations and after some period of time suppose the master starts properly then again my application automatically connect to master as like previous, and if both master and slave fails then the application should connect to main server. Actually my application supports the hub and spoke model. If any way i can do this scenario with the postgres please suggest me the tools which should i used.
i have one master and one slave database if the any way master is crashed then application automatically connect to slave for further operations and after some period of time suppose the master starts properly then again my application automatically connect to master as like previous, and if both master and slave fails then the application should connect to main server. Actually my application supports the hub and spoke model. If any way i can do this scenario with the postgres please suggest me the tools which should i used.