Обсуждение: PgpoolII auto fail-over
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
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
Hi Arvind,
Go through this link. hope this will help you.
Go through this link. hope this will help you.
On Wed, Dec 19, 2018 at 11:38 AM arvind chikne <arvind.chikne@gmail.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 chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail
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@gmail.com> wrote:
Hi Arvind,
Go through this link. hope this will help you.On Wed, Dec 19, 2018 at 11:38 AM arvind chikne <arvind.chikne@gmail.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 chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail
Thanks & Regards
Arvind rao chikne
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
And also facing problem with pgpool with jdbc application is not able to connect with the database below is the connector details
On Fri, Dec 21, 2018 at 3:27 PM arvind chikne <arvind.chikne@gmail.com> wrote:
Thanks Shreeyansh, Its working, but bit confuse with the auto failover, its not working, pls see below the failover.sh script#!/bin/shfailed_node=$1new_master=$2(dateecho "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.logOn Wed, Dec 19, 2018 at 12:05 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:Hi Arvind,
Go through this link. hope this will help you.On Wed, Dec 19, 2018 at 11:38 AM arvind chikne <arvind.chikne@gmail.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 chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail--Thanks & Regards
Arvind rao chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail
Thanks & Regards
Arvind rao chikne
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
Hi Arvind,
What error you faced during connectivity?
What error you faced during connectivity?
Please check the pgpool log and Application log?
On Fri, Dec 21, 2018 at 4:23 PM arvind chikne <arvind.chikne@gmail.com> wrote:
And also facing problem with pgpool with jdbc application is not able to connect with the database below is the connector detailsOn Fri, Dec 21, 2018 at 3:27 PM arvind chikne <arvind.chikne@gmail.com> wrote:Thanks Shreeyansh, Its working, but bit confuse with the auto failover, its not working, pls see below the failover.sh script#!/bin/shfailed_node=$1new_master=$2(dateecho "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.logOn Wed, Dec 19, 2018 at 12:05 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:Hi Arvind,
Go through this link. hope this will help you.On Wed, Dec 19, 2018 at 11:38 AM arvind chikne <arvind.chikne@gmail.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 chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail--Thanks & Regards
Arvind rao chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail--Thanks & Regards
Arvind rao chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail
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@gmail.com> wrote:
Hi Arvind,
What error you faced during connectivity?Please check the pgpool log and Application log?On Fri, Dec 21, 2018 at 4:23 PM arvind chikne <arvind.chikne@gmail.com> wrote:And also facing problem with pgpool with jdbc application is not able to connect with the database below is the connector detailsOn Fri, Dec 21, 2018 at 3:27 PM arvind chikne <arvind.chikne@gmail.com> wrote:Thanks Shreeyansh, Its working, but bit confuse with the auto failover, its not working, pls see below the failover.sh script#!/bin/shfailed_node=$1new_master=$2(dateecho "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.logOn Wed, Dec 19, 2018 at 12:05 PM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:Hi Arvind,
Go through this link. hope this will help you.On Wed, Dec 19, 2018 at 11:38 AM arvind chikne <arvind.chikne@gmail.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 chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail--Thanks & Regards
Arvind rao chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail--Thanks & Regards
Arvind rao chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail
Thanks & Regards
Arvind rao chikne
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail