Re: PgpoolII auto fail-over

Hi Shreeyansh,

Pls see below the error while application is trying to connect with pgpool

26-Dec-2018 13:11:07.669 WARNING [localhost-startStop-1]
org.postgresql.jdbc.PgConnection.isValid Validating connection.
org.postgresql.util.PSQLException: An I/O error occurred while sending to
the backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)

On Fri, Dec 21, 2018 at 5:34 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
wrote:

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

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