Proper management of PGPool II
- by Cathy
Currently I have a site, with one Postgres database server. It is just for a select number of users (less than ten) but it needs the maximum uptime possible.
I would like some kind of automatic failover for the database.
So I was thinking something like: one server running PGPool II, one running Postgres as master, one running Postgres as slave. But then, if wherever PGPool is running suddenly loses power (or dies, or whatever), there's a single point of failure and the whole thing goes down.
Is there a solution, assuming that outsourcing this to someone else isn't possible?