Обсуждение: Pgpool error
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@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@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@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
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail
Hi Arvind,
Go through the below link..
https://medium.com/@victor.boissiere/how-to-setup-postgresql-cluster-with-repmgr-febc2f10c243
Hope this helps..
Go through the below link..
https://medium.com/@victor.boissiere/how-to-setup-postgresql-cluster-with-repmgr-febc2f10c243
Hope this helps..
On Wed, Oct 17, 2018 at 11:49 AM arvind chikne <arvind.chikne@gmail.com> wrote:
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@Master:~$ cat repmgr/repmgr.confcluster=db_clusternode=1node_name=pgdb1conninfo='host=pgdb1 user=repmgr dbname=repmgr'pg_bindir=/usr/lib/postgresql/9.5/bin/master_response_timeout=5reconnect_attempts=2reconnect_interval=2failover=manualpromote_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@Master:~$ /usr/lib/postgresql/9.5/bin/repmgr -f /var/lib/postgresql/repmgr/repmgr.conf cluster showRole | Connection String* master | host=pgdb1 user=repmgr dbname=repmgrSlave:-postgres@pgdb2:~$ vim repmgr/repmgr.confcluster=db_clusternode=2node_name=pgdb2conninfo='host=pgdb2 port=5432 user=repmgr dbname=repmgr'pg_bindir=/usr/lib/postgresql/9.5/bin/master_response_timeout=5reconnect_attempts=2reconnect_interval=2failover=manualpromote_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 chikne9818979986Think Green!!! Please consider your environmental responsibility before printing this e-mail