Scrape multiple postgres datasources by postgresql exporter

[JaroVojtek]

Hello
We are deploying postgresql-exporter into Kubernetes using helm chart stable/prometheus-postgres-exporter.

In values.yaml helm-chart is section about datasource configuration, which should be configured to tell exporter, which postgresql database endpoint should be scrapped.

config:
  datasource:
    host: <ip_address>
    user: <user>
    password: <password>
    port: "5432"
    database: ''
    sslmode: disable

Inserted values are used for creating secret in Kubernetes, where data section contains encoded postgresql connection string into DB, (e.g. decoded) :

kind: Secret
metadata:
  name: RELEASE-NAME-prometheus-postgres-exporter
  labels:
    app: prometheus-postgres-exporter
    chart: prometheus-postgres-exporter-0.4.0
    heritage: Tiller
    release: RELEASE-NAME
type: Opaque
data:
  data_source_name: "postgresql://<user>:<password>@<ip_address>:5432/?sslmode=disable"

Is there an option to configure more than one datasources in values.yaml file to tell exporter to scrape 2 database endpoint for example:

config:
  datasource:
    host: [<ip_address1>, <ip_address2>]
    user: <user>
    password: <password>
    port: "5432"
    database: ''
    sslmode: disable

Or make content of data_source_name in different format, e.g.:

data:
  data_source_name: "user=<user>, password=<password>, host=<ip_address1>, host=<ip_address2>, sslmode=disable, port=5432"

Did somebody have this kind of use-case? Is there a solution for doing this?

Thank you

[JaroVojtek]

I already found a solution

1. latest version of wrouesnel/postgres_exporter need to be used
2. content of data_source_name should follow syntax: postgresql://<user1>:<user1>@<ip_addr1>:5432/?sslmode=disable,postgresql://<user2>:<user2>@<ip_addr2>:5432/?sslmode=disable

This issue can be closed. Hopefully it will help somebody

[uttarwar-yogesh]

Hi,

How to pass password in encrypted format.

Thanks.
Yogesh.

[Den-KP]

I already found a solution

1. latest version of wrouesnel/postgres_exporter need to be used
2. content of data_source_name should follow syntax: postgresql://<user1>:<user1>@<ip_addr1>:5432/?sslmode=disable,postgresql://<user2>:<user2>@<ip_addr2>:5432/?sslmode=disable

This issue can be closed. Hopefully it will help somebody

Hi! Could you please share an example of your final config.
I have problem with connect multi docker databases in psotgresql-exporter.
I try add in values.yml:
config:
datasource:
# Specify one of both datasource or datasourceSecret
host: hots1, host2
user: user_test, user_dev
# Only one of password and passwordSecret can be specified
password: pass1, pass2
# Specify passwordSecret if DB password is stored in secret.
passwordSecret: {}
# Secret name
# name:
# Password key inside secret
# key:
port: "5449", "5448"
database: 'postgres', 'postgres'
sslmode: disable
datasourceSecret: {}
# Specifies if datasource should be sourced from secret value in format: postgresql://login:password@hostname:port/dbname?sslmode=disable
# Multiple Postgres databases can be configured by comma separated postgres connection strings
# Secret name
# name:
# Connection string key inside secret
# key: