Unable to use postgres exporter with azure flexible database

Nitin Naidu (Consultant) 46 Reputation points
2023-01-31T18:31:32.7+00:00

I get below error in place of metrics when I deploy the helm chart for postgres exporter:

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
Azure Database for PostgreSQL
{count} votes