0000588: I cant stop/promtye backend node ( master or salve) from pgpooladmin

ID	Project	Category	View Status	Date Submitted	Last Update

0000588	Pgpool-II	General	public	2020-02-27 18:05	2020-04-14 12:51

Reporter	loay	Assigned To	pengbo
Priority	normal	Severity	major	Reproducibility	always
Status	feedback	Resolution	open
Product Version	4.0.2

Summary	0000588: I cant stop/promtye backend node ( master or salve) from pgpooladmin
Description	Hello, I have setup two pg servers verion 11 on debian 10 using repmgr I have installed pgpool 4.0.2 on third server to load balance the traffic toward two backend server , when i tried to stop node from pgpoool admin I got the attached error .
Additional Information	Repmgr gives everything ok
Tags	error, pgpool in load balancing mode

loay 2020-02-27 18:05 reporter	pcp.conf (42 bytes) pgpool.conf (38,115 bytes) pool_hba.conf (3,458 bytes) pool_passwd (82 bytes) pool_passwd (82 bytes) Capture.PNG (64,843 bytes) Capture.PNG (64,843 bytes)

pengbo 2020-03-04 12:57 developer ~0003237	Did you installed "pgpool-II-pgxx-extensions" and created pgpool_recovery extension in template1? $ yum install pgpool-II-pgxx-extensions $ psql template1 -c "CREATE EXTENSION pgpool_recovery"

pengbo 2020-04-14 12:51 developer ~0003315	If you have resolved this issue, may I close it?

Date Modified	Username	Field	Change
2020-02-27 18:05	loay	New Issue
2020-02-27 18:05	loay	File Added: pcp.conf
2020-02-27 18:05	loay	File Added: pgpool.conf
2020-02-27 18:05	loay	File Added: pool_hba.conf
2020-02-27 18:05	loay	File Added: pool_passwd
2020-02-27 18:05	loay	File Added: Capture.PNG
2020-02-27 18:05	loay	Tag Attached: error
2020-02-27 18:05	loay	Tag Attached: pgpool in load balancing mode
2020-02-28 09:32	pengbo	Assigned To	=> pengbo
2020-02-28 09:32	pengbo	Status	new => assigned
2020-03-04 12:57	pengbo	Note Added: 0003237
2020-03-11 12:52	pengbo	Status	assigned => feedback
2020-04-14 12:51	pengbo	Note Added: 0003315