our ADO.net application uses npgsql to connect to postgresql database. We have implemented a normal cluster of 2 servers(master and slave) as of now.

As we don't want to change the database connection string in the application during failover, Is there any other way except VIP to point the application to the new master server after failover?

We are using postgresql-9.6.

  • It seems pgPool can do that – a_horse_with_no_name Feb 11 at 16:08
  • If you used anything else than .NET, it would be easy with the built-in multi-host connection strings available elsewhere. – Laurenz Albe Feb 11 at 16:43
  • @LaurenzAlbe could you please share any link to do it using VIP – Yogi Feb 17 at 9:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.