Hello,
It is very good to see PostgreSQL Cluster manager Patroni’s metrics inside PostgreSQL dashboards. I got patroni metrics from patroni_exporter and using Grafana dashboard (ID 66). Is it possible to do that?
2 Likes
Hi @Cihan_Tunali , thanks for posting to the Percona forums!
What you’re asking for is completely possible with PMM! You’ll want to use what is known as External Services. You’ll need to set up the exporter, then you can add it to PMM via the following example command:
pmm-admin add external --listen-port=9393 --service-name=db1-patroni
As you’ve already identified a dashboard, you simply need to be logged into PMM with an admin account and you can import the dashboard. Note you may need to change the name of the Data Source to Metrics in order to properly source the data.
Best of luck and let us know how you make out!
1 Like
Hello,
In the recent version of PMM 2.41.2
I tried to add a patroni node into PMM, but unfortunately our Patroni is using https, when using external it uses https://127.0.0.1 and sadly 127.0.0.1 is not defined in SAN of the certificate so it cannot be trusted,
Is there a way to connect a patroni api through https with a custom server name using the “external service” ?
Thanks