Pgpool error

From: arvind chikne <arvind(dot)chikne(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Pgpool error
Date: 2018-10-17 06:18:38
Message-ID: CAHVLh7SzCzznA9j4DCmy8ppfbGUVmnVwR9mDiaJpmXWh-7n=Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

While joining the DB_cluster i am having the below error

$repmgr -f /var/lib/postgresql/repmgr/repmgr.conf standby register

*[2018-10-17 11:42:59] [ERROR] this node should be a standby (host=pgdb2
port=5432 user=repmgr dbname=repmgr)*

*Master:-*
*postgres(at)Master:~$ cat repmgr/repmgr.conf*
*cluster=db_cluster*
*node=1*
*node_name=pgdb1*
*conninfo='host=pgdb1 user=repmgr dbname=repmgr'*
*pg_bindir=/usr/lib/postgresql/9.5/bin/*
*master_response_timeout=5*
*reconnect_attempts=2*
*reconnect_interval=2*
*failover=manual*
*promote_command='/usr/lib/postgresql/9.5/bin/repmgr standby promote -f
/var/lib/postgresql/repmgr/repmgr.conf'*
*follow_command='/usr/lib/postgresql/9.5/bin/repmgr standby follow -f
/var/lib/postgresql/repmgr/repmgr.conf'*

$postgres(at)Master:~$ /usr/lib/postgresql/9.5/bin/repmgr -f
/var/lib/postgresql/repmgr/repmgr.conf cluster show
Role | Connection String
* master | host=pgdb1 user=repmgr dbname=repmgr

*Slave:-*
*postgres(at)pgdb2:~$ vim repmgr/repmgr.conf*
*cluster=db_cluster*
*node=2*
*node_name=pgdb2*
*conninfo='host=pgdb2 port=5432 user=repmgr dbname=repmgr'*
*pg_bindir=/usr/lib/postgresql/9.5/bin/*
*master_response_timeout=5*
*reconnect_attempts=2*
*reconnect_interval=2*
*failover=manual*
*promote_command='/usr/lib/postgresql/9.5/bin/repmgr standby promote -f
/var/lib/postgresql/repmgr/repmgr.conf'*
*follow_command='/usr/lib/postgresql/9.5/bin/repmgr standby follow -f
/var/lib/postgresql/repmgr/repmgr.conf'*

*Pls guide me whatis wrong in my configuration *
--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-10-17 11:20:55 Re: Pgpool error
Previous Message samuel.cc 2018-10-17 05:55:49 Slow client connection to postgresql server