View Issue Details

IDProjectCategoryView StatusLast Update
0000588Pgpool-II[All Projects] Generalpublic2020-04-14 12:51
ReporterloayAssigned Topengbo 
PrioritynormalSeveritymajorReproducibilityalways
Status feedbackResolutionopen 
Product Version4.0.2 
Target VersionFixed in Version 
Summary0000588: I cant stop/promtye backend node ( master or salve) from pgpooladmin
DescriptionHello,

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 InformationRepmgr gives everything ok


Tagserror, pgpool in load balancing mode

Activities

loay

2020-02-27 18:05

reporter  

Capture.PNG (64,843 bytes)
Capture.PNG (64,843 bytes)
pool_passwd (82 bytes)
postgres:5f4dcc3b5aa765d61d8327deb882cf99
pgpool:ba777e4c2f15c11ea8ac3be7e0440aa0
pool_passwd (82 bytes)
pool_hba.conf (3,458 bytes)
pgpool.conf (38,115 bytes)
pcp.conf (42 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?

Issue History

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