From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | arvind chikne <arvind(dot)chikne(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PgpoolII auto fail-over |
Date: | 2018-12-21 12:02:24 |
Message-ID: | CAGDYbUM1uoACN18C30Ogy1tkmRqeTo8KD047FK_69U3RHCXsyA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Arvind,
What error you faced during connectivity?
Please check the pgpool log and Application log?
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
On Fri, Dec 21, 2018 at 4:23 PM arvind chikne <arvind(dot)chikne(at)gmail(dot)com>
wrote:
> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dhandapani Shanmugam | 2018-12-24 10:27:49 | PostgreSQL HA |
Previous Message | arvind chikne | 2018-12-21 10:53:29 | Re: PgpoolII auto fail-over |