ome/ansible-role-prometheus-postgres

Prometheus Postgres exporter

Prometheus Postgres

Prometheus Postgres exporter.

This currently uses the local postgres administrator account on the PostgreSQL server. In future this should be changed to use an unprivileged account.

See https://github.com/prometheus-community/postgres_exporter

Role Variables

All variables are optional:

• prometheus_postgres_dbname: The database name
• prometheus_postgres_data_source_name: implies DATA_SOURCE_NAME ENV variable in the postgres_exporter
• prometheus_postgres_port: Serve metrics on this port, default 9187
• prometheus_postgres_query_directory: the directory containing query files which will be loaded by the exporter, default is files/
• prometheus_postgres_query_filenames: A list of additional query files from prometheus_postgres_query_directory, default [queries-default.yml]
• prometheus_postgres_version: the postgres_exporter version to be installed, default 0.4.6
• prometheus_postgres_sha256: the SHA256 checksum of the postgres_exporter bundle of version prometheus_postgres_version, default: 9ed457c9a6d3a1e0132b3fe10f1d072457a667b009993a73e90b47ca99cc5bca
• prometheus_postgres_system_user: The OS user used to run postgres_exporter, default: postgres (OS user is created only when differs from defaults).

Example playbook

- hosts: localhost
  roles:
  - role: ome.prometheus_postgres
    prometheus_postgres_dbname: test

Author Information

[email protected]

ansible-role-prometheus-postgres's Issues

Supporting non-superuser

I see in the postgres-exporter had supported non-superuser. And seems like the ansible role is still using postgres user. Can you confirm that?

I'm planning to update this changes into the role, do you have any instruction or idea how I should do it? Thanks!

Improve role automation

Hi! Thanks for the role!

There's a few rough edges in the role, for me the more breaking one is to manually input the version and checksum.

I will see if I can make a PR with a few updates, leaving it more like https://github.com/cloudalchemy/ansible-node-exporter.

Evaluate checksumming of releases

          Agreed, thanks, @GlauberrBatista. The checksumming is less thorough now, but we can re-evaluate that step in a future release.

Originally posted by @joshmoore in #15 (review)