Re: PgpoolII auto fail-over

[arvind chikne <arvind.chikne@xxxxxxxxx>]

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@xxxxxxxxx> 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.chikne@xxxxxxxxx> 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 = "" href="http://192.168.0.164:9999/db_name" target="_blank">192.168.0.164:9999/db_name

On Fri, Dec 21, 2018 at 3:27 PM arvind chikne <arvind.chikne@xxxxxxxxx> 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@xxxxxxxxx> wrote:

Hi Arvind,

Go through this link. hope this will help you.

http://www.pgpool.net/docs/latest/en/html/example-cluster.html

On Wed, Dec 19, 2018 at 11:38 AM arvind chikne <arvind.chikne@xxxxxxxxx> 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