One thing that I don't know how to made with postgresql. I use pgsql 9.2 on Centos 6.4. I normally use system in HA and database is a critical point.
Now I have 2 servers with some services and 2 Postgresql with Pgpool setting.
I want when master die, any other service die and I kill this node, all new data based on slave machine, when the other machine power on sync all data automatic.
Any tool to make this?