This question has been archived.

Getting a true FT PostgreSQL install

October 13, 2014 1.6k views

I am trying to get a truly high available PostgreSQL install. Losing any individual box in my system should not cause an impact of over a few second to the running system.

I see I can do something like this with 2 PostgreSQL installs, and 2 instances of PgPool (1 on each PostgreSQL server):

But - that plan requires a virtual IP, which DIgital Ocean will not give you.

Is there another way to achieve something similar without using virtual IP failover?

Be the first one to answer this question.