[pgpool-general: 4131] Re: Testing pgpool + failover on random servers restarts

[Ioana Danes]

Hello,

Sorry for late reply on this issue, I've been busy with other tasks.

On Fri, Oct 16, 2015 at 7:05 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:

>
> > Is there a way I
> > could overcome this issue? I thought I could update the pgpool status
> file
> > in /var/log/pgpool in my scripts once a failover occurs. Would that be
> the
> > way to go or there are better ways to fix this?
>
> The situation above heavily relies on how you wrote pgpool_failover.sh
> and pgpool_failback.sh. Also you'd better present how you start
> pgpool. The point here is, you use -D or not.
>
>
I start pgpool using the /etc/init.d/pgpool-II script:

PGPOOL2_BIN=/usr/sbin/pgpool
test -x $PGPOOL2_BIN || { echo "$PGPOOL2_BIN not installed";
        if [ "$1" = "stop" ]; then exit 0;
        else exit 5; fi; }

# Check for existence of needed config file and read it
PGPOOL2_CONFIG=/etc/sysconfig/pgpool-II
test -r $PGPOOL2_CONFIG || { echo "$PGPOOL2_CONFIG not existing";
        if [ "$1" = "stop" ]; then exit 0;
        else exit 6; fi; }

# Read config
. $PGPOOL2_CONFIG
PGPOOL2_CONFFILE="/etc/pgpool-II/pgpool.conf"
PGPOOL2_PID="/var/run/pgpool/pgpool.pid"

...

    start)
        echo -n "Starting pgpool "
        ## Start daemon with startproc(8). If this fails
        ## the return value is set appropriately by startproc.
        /sbin/startproc -u pgpool -g pgpool $PGPOOL2_BIN

        # Remember status and be verbose
        rc_status -v
        sleep 1


and this is my failover script:

#!/bin/sh

crt_date=`date`
echo "$crt_date : old master id=$1 new master id=$2 new master host=$3" >>
${log_file}

old_master_id=$1
new_master_id=$2
new_master_host=$3

if [ ${old_master_id} -ne ${new_master_id} ]
then
        ssh root@${new_master_host}
"/cbnDBscripts/DBCluster/dbcluster_promote_as_primary.sh" >
/cbnDBscripts/log/pgpool_failover_${new_master_host}.log
else
        ssh root@${new_master_host}
"/cbnDBscripts/DBCluster/dbcluster_standby_failed.sh" >
/cbnDBscripts/log/pgpool_failover_slave_${new_master_host}.log
fi


Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>


Thanks a lot for your help,
Ioana
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151021/0aef5293/attachment.html>