[pgpool-general: 3492] Fwd: Reg Failover script in Pgpool

[Gurunadh Venkata]

Hi all,


Can anyone please let me the failover_script which is Working fine in
pgpool.conf .What are all the other important parameters need to be
configured in pgpool.conf file to work the failover feature as expected.

Following is the failover script i am using.

DB version PPAS 9.4AS(EnterpriseDB)

pgpool   version 3.3.4

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 enterprisedb -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/20150302/65ad14c6/attachment.htm>