Report this

What is the reason for this report?

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

Posted on March 16, 2016

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.



This textbox defaults to using Markdown to format your 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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.