Hi,
I want to add plugin on my Pmm but this is not work
I connect my PostgreSQL
I run select and result following
postgres=# SELECT * FROM pg_available_extensions WHERE name = ‘pg_stat_statements’;
name | default_version | installed_version | comment
--------------------±----------------±------------------±----------------------------------------------------------
pg_stat_statements | 1.7 | 1.7 | track execution statistics of all SQL statements executed
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
--------------------±--------±-----------±-------------------------------------------------------------
dblink | 1.2 | public | connect to other PostgreSQL databases from within a database
pg_stat_statements | 1.7 | public | track execution statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(3 rows)
I run on root account following command;
pmm-admin add postgresql:metrics --user postgres HOSTNAME-postgrsql-- --extend.query-path /home/USERNAME/queries.yaml
Result :
pmm-admin: error: expected command but got “postgresql:metrics”, try --help
I run on root account following command;
pmm-admin add external:metrics –user pmm_user –password ‘pmm_user_password’ postgres –host HOSTNAME –port 5432 –service-port 9187 –disable-ssl –extend.query-path /home/USERNAME/queries.yaml
Result :
pmm-admin: error: expected command but got “postgresql:metrics”, try --help
I don’t understand
I check with pmm-admin --help but there is not pmm-admin add postgresql:metrics command
pmm-admin --help
usage: pmm-admin [] [ …]
Version 2.26.0
Flags:
-h, --help Show context-sensitive help (also try --help-long and --help-man)
–server-url=SERVER-URL PMM Server URL in https://username:password@pmm-server-host/ format
–server-insecure-tls Skip PMM Server TLS certificate validation
–debug Enable debug logging
–trace Enable trace logging (implies debug)
–json Enable JSON output
-v, --version Show application version
Commands:
help […]
Show help
annotate []
Add an annotation to Grafana charts
config [] [] [] []
Configure local pmm-agent
list []
Show Services and Agents running on this Node
status []
Show information about local pmm-agent
summary []
Fetch system data for diagnostics
add external --listen-port=LISTEN-PORT []
Add External source of data (like a custom exporter running on a port) to the monitoring
add external-serverless []
Add External Service on Remote node to monitoring.
Usage example: sudo pmm-admin add external-serverless --url=http://1.2.3.4:9093/metrics
Also, individual parameters can be set instead of --url like: sudo pmm-admin add external-serverless --scheme=http --host=1.2.3.4 --listen-port=9093 --metrics-path=/metrics --container-name=ddd --external-name=e125
Notice that some parameters are mandatory depending on the context. For example, if you specify --url, --schema and other related parameters are not mandatory but, if you specify --host you must provide all other parameters
needed to build the destination URL or even you can specify --address instead of host and port as individual parameters.
add haproxy --listen-port=LISTEN-PORT [] []
Add HAProxy to monitoring
add mongodb [] [] []
Add MongoDB to monitoring
add mysql [] [] []
Add MySQL to monitoring
add postgresql [] [] []
Add PostgreSQL to monitoring
add proxysql [] [] []
Add ProxySQL to monitoring
register [] [] [] []
Register current Node at PMM Server
remove [] []
Remove Service from monitoring
unregister []
Unregister current Node from PMM Server
How do I add this plugin on pmm?