Re: Pgpool error

Hi Arvind,

Go through the below link..

https://medium.com/@victor.boissiere/how-to-setup-postgresql-cluster-with-repmgr-febc2f10c243

Hope this helps..

<http://www.shreeyansh.com>

On Wed, Oct 17, 2018 at 11:49 AM arvind chikne <arvind(dot)chikne(at)gmail(dot)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(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
>
>