Re: PgpoolII auto fail-over

And also facing problem with pgpool with jdbc application is not able to
connect with the database below is the connector details

connection.url = jdbc:postgresql://192.168.0.164:9999/db_name

On Fri, Dec 21, 2018 at 3:27 PM arvind chikne <arvind(dot)chikne(at)gmail(dot)com>
wrote:

> 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
>
>

--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail