-
Notifications
You must be signed in to change notification settings - Fork 725
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Metrics are not visible for Azure Postgress PaaS service #401
Comments
Hi how can actually have the exporter connect correctly to managed postgres? |
Did you find a solution for that ? |
For the record, the new (still in preview) Azure Flexible Server no longer has that user@instance login thing. |
when I try to connect the Postgres on Azure, I get the following error:
so that means the postgres-exorter can not support the Azure Postgres? thanks |
@songleo it seems you haven't whitelisted the IP the exporter is connecting from, so Azure rejects it: |
You also have to set ssl to required
Le jeu. 7 avr. 2022 à 12:05, Michael Banck ***@***.***> a
écrit :
… @songleo <https://github.com/songleo> it seems you haven't whitelisted
the IP the exporter is connecting from, so Azure rejects it: pq: no
pg_hba.conf entry for host \"66.187.232.127\",
—
Reply to this email directly, view it on GitHub
<#401 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADRP4PPREILTOXKNTPABQ6TVD2XODANCNFSM4NRODGOA>
.
You are receiving this because you commented.Message ID:
***@***.***>
|
@mbanck thank you so much, but the IP is dynamic. so do you know how to handle this case? |
thanks, let me try it with the SSL |
@mbanck do we have a doc or guide I can follow with? thanks |
There's nothing to follow and this is not postgres_exporter specific, this is basic managed postgres - You need to use a VPN or deploy postgres_exporter on a VM with stable IP or something. |
Hi all,
We are using postgres_exporter in Kubernetes environment to fetch postgres metrics. And for monitoring we are using Grafana with Prometheus as a data source.
In Postgres-exporter DATA_SOURCE_NAME we are putting Azure PostgreSQL PaaS service details with "ssmode=require".
But the metrics are not able to showing any data when we execute any pg_* in Prometheus.
don't know why it is happening.
Also in postgres_exporter there in no such error or warning message.
Can someone please help?
The text was updated successfully, but these errors were encountered: