Question

I need a Virtual Private IP for an failover setup of pgpool-II.

I need a Virtual Private IP for an failover setup of pgpool-II. How do I get Vitual Private IP? I want to setup a cluster of 2 pgpool-II instance and my app should access it with common identity through private communication how do I achieve that if Virtual Private IP is not available.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

In a cloud environment, you may not be able to use a traditional Virtual Private IP. Though on DigitalOcean, you can use a Floating IP for situations like this. With pgpool-II you can provide a script that will be executed as the failover happens. In this script, you can assign the Floating IP from one instance to the other. This simple Python script or the DigitalOcean command line client could be used in your failover script to move a Floating IP.