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