[pgpool-general: 3487] Reg Failover script in Pgpool

[Gurunadh Venkata]

Dear All,


I have setup the load balancing and failover for Availability in pgpool. I
have used the Master-slave replication(stream mode) for replication.

The following is my failover_command ='/usr/local/etc/failover.sh %d %P %H
%R'


Following is the failover script.

#!/bin/bash -x
FALLING_NODE=$1         # %d
OLDPRIMARY_NODE=$2      # %P
NEW_PRIMARY=$3          # %H
PGDATA=$4               # %R

if [ $FALLING_NODE = $OLDPRIMARY_NODE ]; then
    if [ $UID -eq 0 ]
    then
        su postgres -c "ssh -T enterprisedb@$NEW_PRIMARY touch $PGDATA/trigger"
    else
        ssh -T enterprisedb@$NEW_PRIMARY touch $PGDATA/trigger
    fi
    exit 0;
fi;
exit 0;


To check the  failover scenario i have stopped the master database
server.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

show pool_nodes;

o/p:

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
(2 rows)


Please help me in Fixing this Issue.Provide me the working failover
script if any.


Thanks for your time.




Thanks & Regards,
G V Gurunadh.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150226/9d62a209/attachment.htm>