Signed-off-by: Joe Adams <github@joeadams.io>

Signed-off-by: Joe Adams <github@joeadams.io>

Co-authored-by: Ben Kochie <superq@gmail.com>

It looks like postgres 14.1 was added to CI here:

https://github.com/prometheus-community/postgres_exporter/commit/fcb2535affa0f97c7a11439c19de6a7ff793e0df

See also: https://github.com/prometheus-community/postgres_exporter/issues/651#issuecomment-1156947591



Signed-off-by: Austin Godber <godber@uberhip.com>

This moves the metrics that are queried from pg_stat_bgwriter into a dedicated collector instead of dynamically generating queries and metrics from a map. It renames some metrics including adding the `_total` suffix on all of the counters to match prometheus standards. This implementation uses QueryRowContext to allow for later addition of context for cancellation. From the Postgres documentation, it states that there is one line per WAL sender process, but it is unclear how to differentiate between them in any meaningful way. When querying the table, there is no column to identify the row, only metrics about bgwriter.

Signed-off-by: Joe Adams <github@joeadams.io>

Reference here: https://grafana.com/docs/agent/latest/configuration/integrations/postgres-exporter-config/


Also, matches the environment variables section.

Signed-off-by: Alex Ruddick <a.ruddick@numat-tech.com>

Signed-off-by: juris.greitans <juris.greitans@visma.com>

Signed-off-by: juris.greitans <juris.greitans@visma.com>

Getting the error when adding non-root postgres user for exporter:
```
postgres=# CREATE OR REPLACE FUNCTION get_pg_stat_statements() RETURNS SETOF pg_stat_statements AS
postgres-# $$ SELECT * FROM public.pg_stat_statements; $$
postgres-# LANGUAGE sql
postgres-# VOLATILE
postgres-# SECURITY DEFINER;
ERROR:  type "pg_stat_statements" does not exist
```
Add following sql command for enable pg_stat_statements:
```
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
```

Signed-off-by: Xela Tirdan <xelatirdan@gmail.com>

Signed-off-by: Magnus Hagander <magnus@hagander.net>

Signed-off-by: Alex Vandiver <alex@chmrr.net>

Signed-off-by: Paul van der Linden <mail@paultjuh.org>

Signed-off-by: Pavel Sapezhko <me@weastur.com>

Signed-off-by: Julien Pivotto <roidelapluie@inuits.eu>

Setup integration test matrix in CircleCI.
* Update README integration testing list.

Signed-off-by: Ben Kochie <superq@gmail.com>

Add standard Prometheus build setup
* CircleCI config
* Makefile
* Go modules
* Golang-CI Lint
* promu config
* Remove /vendor
* Remove mage build
* Update READMEs

https://github.com/prometheus-community/postgres_exporter/issues/478



Signed-off-by: Ben Kochie <superq@gmail.com>

Have a custom prefix for each of the default metrics created by postgres_exporter

Co-authored-by: Will Rouesnel <wrouesnel@wrouesnel.com>

this has a minor change to the wording and a couple of examples to demonstrate
the use of DATA_SOURCE_URI.

Closes #113

* Update README according --help output

* Update environment variables list in README

Closes #326 as is provides a viable solution to use a K8S init container
to fully contruct the PostgreSQL URI and 'hand it over' to the postgres_exporter
process.

To resolve the error below, it was necessary to add a new grant to the database postgres.

Error: 'pq: permission denied for database \ "postgres \"'

* Discover only databases that are not templates and allow connections

* Update readme

* Add exclude-databases option
* Update readme to explain --exclude-databases
* Add comments to ExcludeDatabases function and unexport Contains function

Make the SQL work in automated deployments where it will be repeated many times.

Allow non-superuser commands to be re-run without (some) errors.

add ; for any users that are copy/pasting from the readme

Update the running as non-superuser section. This solves the problem that certain metrics didn't produce a value.

This functionality was added in c225a1e1
but not documented.

Improve the documentation for `--disable-default-metrics` and update the listing of current flags.