[pgpool-general: 3490] Re: Reg Failover script in Pgpool
atoth at gravity.com
Fri Feb 27 07:38:09 JST 2015
There's a lot to look at. For starters, make sure your recovery.conf
has $PGDATA/trigger as the trigger file and not some other path. Also
check the pgpool.log to see if pgpool even tried to elect a new master.
The best thing you can do after that is to su to the user pgpool runs as
on your pgpool node and run "sh -x /usr/local/etc/failover.sh . . . "
with the arguments you expect pgpool would have run and see what it
does. It could be something as simple as having to accept an ssh host
key (for which I suggest adding "-o StrictHostKeyChecking=no" to your
script's ssh command so you don't have that problem).
On 2/25/15 22:19, Gurunadh Venkata wrote:
> Dear All,
> I have setup the load balancing and failover for Availability in
> pgpool. I have used the Master-slave replication(stream mode) for
> 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 ]
> su postgres -c "ssh -T enterprisedb@$NEW_PRIMARY touch $PGDATA/trigger"
> ssh -T enterprisedb@$NEW_PRIMARY touch $PGDATA/trigger
> exit 0;
> 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;
> 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.
> pgpool-general mailing list
> pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general