Getting a true FT PostgreSQL install
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?