From: | arvind chikne <arvind(dot)chikne(at)gmail(dot)com> |
---|---|
To: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PgpoolII auto fail-over |
Date: | 2018-12-21 09:57:03 |
Message-ID: | CAHVLh7SYS+JKZ1aO_OyPtRsRKsURJmi3u1cdyBqB6=LZrz1dwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks Shreeyansh, Its working, but bit confuse with the auto failover, its
not working, pls see below the failover.sh script
#!/bin/sh
failed_node=$1
new_master=$2
(
date
echo "Failed node: $failed_node"
set -x
/usr/bin/ssh -T -l postgres $new_master "/usr/pgsql-9.5/bin/repmgr -f
/var/lib/postgresql/repmgr/repmgr.conf standby promote 2>/dev/null
1>/dev/null <&-"
exit 0;
) 2>&1 | tee -a /tmp/pgpool_failover.log
On Wed, Dec 19, 2018 at 12:05 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
wrote:
> Hi Arvind,
>
> Go through this link. hope this will help you.
> http://www.pgpool.net/docs/latest/en/html/example-cluster.html
>
> <http://www.shreeyansh.com>
>
>
> On Wed, Dec 19, 2018 at 11:38 AM arvind chikne <arvind(dot)chikne(at)gmail(dot)com>
> wrote:
>
>> Hi All,
>>
>> I manage to configure the master slave replication for my postgres 9.5,
>> can any one help with the pgpool setup for auto fail-over setup.
>>
>> --
>> *Thanks & Regards*
>> Arvind rao chikne
>> 9818979986
>> *Think Green!!!* Please consider your environmental responsibility
>> before printing this e-mail
>>
>>
--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail
From | Date | Subject | |
---|---|---|---|
Next Message | arvind chikne | 2018-12-21 10:53:29 | Re: PgpoolII auto fail-over |
Previous Message | Simon Riggs | 2018-12-21 09:12:20 | Re: Multi master implementation |