> Am I missing something here? or some mode of pgpool which I am not aware
I thought you were mentioning split-brain for PostgreSQL. For pgpool, I am
using virtual IP. Somehow I got the message that the split-brain/virtual IPs
in your mail were with reference to PostgreSQL servers.
It is. Once pgpool faces a split-brain scenario, it will pass on the same knowledge to respective PostgreSQL nodes. Try it out, the pull the network cable or bring down your router [don't do it in your production :-) ] then check you logs on both database, check your pgpool logs. You will know what I am talking about.
I am not sure if this is still relevant for the person posting the question. But I guess this can benefit others who browse through the archives looking for a similar solution. Here is a link to a nice tutorial with pgpool:
if [ $FALLING_NODE = $OLDPRIMARY_NODE ]; then
if [ $UID -eq 0 ]
su enterprisedb -c "ssh -T enterprisedb@$NEW_PRIMARY touch
ssh -T enterprisedb@$NEW_PRIMARY touch $PGDATA/trigger
To check the failover scenario i have stopped(kill -9) the master db
server process.According to the script the present salve will take over the
role of master. But the same was not happening in my case.
From pgpool end
edb=# show pool_nodes;
node_id | hostname | port | status | lb_weight | role
0 | 10.0.0.149 | 5444 | 3 | 0.500000 | standby
1 | 10.0.0.158 | 5444 | 2 | 0.500000 | standby
Please help me in Fixing this Issue.Provide me the failover script which is working correctly.