Home > mailing lists

Pgpool error - Mailing list pgsql-admin

From	arvind chikne
Subject	Pgpool error
Date	October 17, 2018 09:18:38
Msg-id	CAHVLh7SzCzznA9j4DCmy8ppfbGUVmnVwR9mDiaJpmXWh-7n=Hw@mail.gmail.com Whole thread Raw
Responses	Re: Pgpool error
List	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@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

From: samuel.cc@zohocorp.com
Date: 17 October 2018, 08:55:49
Subject: Slow client connection to postgresql server

From: Shreeyansh Dba
Date: 17 October 2018, 14:20:55
Subject: Re: Pgpool error