prometheus-community / postgres_exporter

A PostgreSQL metric exporter for Prometheus
Apache License 2.0
2.73k stars 725 forks source link

Unable to use postgres exporter with azure flexible database #752

Open nimblenitin opened 1 year ago

nimblenitin commented 1 year ago

What did you do? Tried deploying postgres exporter in aks What did you expect to see? metrics What did you see instead? Under which circumstances? An error has occurred while serving metrics:

7 error(s) occurred:
* collected metric "pg_database_size_bytes" { label:<name:"datname" value:"azure_maintenance" > label:<name:"server" value:"X-dev.postgres.database.azure.com:5432" > gauge:<value:X > } was collected before with the same name and label values
* collected metric "pg_database_size_bytes" { label:<name:"datname" value:"template1" > label:<name:"server" value:"X-dev.postgres.database.azure.com:5432" > gauge:<value:X+06 > } was collected before with the same name and label values
* collected metric "pg_database_size_bytes" { label:<name:"datname" value:"postgres" > label:<name:"server" value:"X-dev.postgres.database.azure.com:5432" > gauge:<value:X+07 > } was collected before with the same name and label values
* collected metric "pg_database_size_bytes" { label:<name:"datname" value:"template0" > label:<name:"server" value:"X-dev.postgres.database.azure.com:5432" > gauge:<value:X+06 > } was collected before with the same name and label values
* collected metric "pg_database_size_bytes" { label:<name:"datname" value:"azure_sys" > label:<name:"server" value:"X-dev.postgres.database.azure.com:5432" > gauge:<value:X+06 > } was collected before with the same name and label values
* collected metric "pg_database_size_bytes" { label:<name:"datname" value:"fhio-temp" > label:<name:"server" value:"X-dev.postgres.database.azure.com:5432" > gauge:<value:X+07 > } was collected before with the same name and label values
* collected metric "pg_database_size_bytes" { label:<name:"datname" value:"X-dev" > label:<name:"server" value:"fhiodatabase-dev.postgres.database.azure.com:5432" > gauge:<value:X+X> } was collected before with the same name and label values
**Environment**
insert list of flags used here
sysadmind commented 1 year ago

You don't include almost any of the necessary information here. What version of the exporter? What flags are you using? Are you using a custom query file (queries.yaml)?