Re: Pgpool error

[Shreeyansh Dba <shreeyansh2014@xxxxxxxxx>]

Hi Arvind,

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@xxxxxxxxx> 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.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

9818979986

Think Green!!! Please consider your environmental responsibility before printing this e-mail