PMM To monitor `pgpool` using `pgpool2_exporter`

Percona Monitoring and Management (PMM) PMM 2.x
1

Description:

[Detailed description of the issue or question]
To monitor pgpool using pgpool2_exporter and how can I connect it with a PMM (Percona Monitoring and Management) server, please help me.

[root@TESTDB01 pgpool2_exporter]# ./pgpool2_exporter
ts=2024-09-02T07:34:55.812Z caller=main.go:53 level=info msg=“Starting pgpool2_exporter” version=“(version=1.2.2, branch=master, revision=06a68dead344308c3346f53aba811c929eff71d5)” dsn=“postgresql://postgres:MASKED_PASSWORD@1.255..:5433/postgres?sslmode=disable”
ts=2024-09-02T07:34:55.812Z caller=main.go:54 level=info msg=“Listening on address” address=:9719

[root@TESTDB01 pmm]# pmm-admin add external --service-name=pgpool --metrics-path=metrics --listen-port=9719
External Service added.
Service ID : /service_id/dad1bf67-0a30-4d44-8cd7-fc46ac454c76
Service name: pgpool
Group : external

[root@TESTDB01 pmm]# pmm-admin list
Service type Service name Address and port Service ID
PostgreSQL DPGTESTDB01 127.0.0.1:5432 /service_id/44c86c96-9be8-4c91-b8d3-7488d1fa1515
External:external pgpool /service_id/dad1bf67-0a30-4d44-8cd7-fc46ac454c76

Agent type Status Metrics Mode Agent ID Service ID Port
pmm_agent Connected /agent_id/3a00d367-b54c-4f13-b1a8-3966c115c217 0
node_exporter Running push /agent_id/4d537cf9-1be2-4a69-85bd-0f908c8e227f 42000
postgres_exporter Running push /agent_id/d5d9cbe4-fdc0-4a1b-a0bd-d328acf09728 /service_id/44c86c96-9be8-4c91-b8d3-7488d1fa1515 42002
postgresql_pgstatmonitor_agent Running /agent_id/26a5ebe0-9f15-49b7-9287-55b9be6817e0 /service_id/44c86c96-9be8-4c91-b8d3-7488d1fa1515 0
external-exporter Unknown push /agent_id/80adc82a-aa0b-4f76-bdfc-76c01df1af78 /service_id/dad1bf67-0a30-4d44-8cd7-fc46ac454c76 9719
vmagent Running push /agent_id/91e7ac96-86ac-4e48-ac02-6ea2599bc827 42001

why status is not running?

2

Hi @jocelynhan,
Do you have data in PMM from this external exporter? Use the PMM Explorer to see if the data is arriving.

3

@jocelynhan status “Unknown” in pmm-admin is OK, as pmm is not controlling the sporter, and we are not sure if it is running correctly.

As @matthewb suggested:
go to PMM_SERVER//graph/d/prometheus-advanced/advanced-data-exploration and type in metric “pgpool2_,” and you should see the list of metrics for pg pool

image
image1962×648 65.6 KB