Unable to use postgres exporter with azure flexible database

Nitin Naidu (Consultant) 51

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

GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee

2023-01-31T22:52:24.7166667+00:00

Hi, @Nitin Naidu (Consultant) Thanks for the ask and using the Microsoft Q&A platform.

Can you try reinstalling the postgres exporter? and also check the configuration of the Postgres exporter.

you can also try installing it from here

Regards

Geetha
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee

2023-02-13T20:42:40.65+00:00

@Nitin Naidu (Consultant) is your issue resolved? can you please provide more details on the issue if it is still exist.

Regards

Geetha

Share via

Unable to use postgres exporter with azure flexible database