Migrate the `pg_locks_count` query from `main` to the `collector`
package.

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

BREAKING CHANGES:

Please note, the following features are deprecated and may be removed in a future release:
- `auto-discover-databases`
- `extend.query-path`
- `constantLabels`
- `exclude-databases`
- `include-databases`

This exporter is meant to monitor PostgresSQL servers, not the user data/databases. If
you need a generic SQL report exporter https://github.com/burningalchemist/sql_exporter


is recommended.

* [CHANGE] Adjust log level for collector startup #784
* [CHANGE] Move queries from queries.yaml to collectors #801
* [CHANGE] Deprecate extend queries feature #811
* [CHANGE] Deprecate additional database features #815
* [CHANGE] Convert pg_stat_database to new collector #685
* [ENHANCEMENT] Supports alternate postgres:// prefix in URLs #787
* [BUGFIX] Fix pg_setting different help values #771
* [BUGFIX] Fix column type for pg_replication_slots #777
* [BUGFIX] Fix pg_stat_database collector #809

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

Now that we have deprecated extended queries we can deprecate related
database features.
* Deprecate flags/functions around auto discover databases.
* Deprecate flags/functions for additional constant labels.

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

Mark the extend queries feature as deprecated in favor of recommending
the sql_exporter.

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

These have not been kept up to date.

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

Update the supported versions based on what we actually test in CI.

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

Update to the latest exporter-toolkit
* Enables multi-listener and systemd socket activation.
* Bump Go to 1.19.
* Remove `PG_EXPORTER_WEB_LISTEN_ADDRESS` env var because this is now a
  repeatable flag.

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

Signed-off-by: Khiem Doan <doankhiem.crazy@gmail.com>

Signed-off-by: Khiem Doan <doankhiem.crazy@gmail.com>

Signed-off-by: Luckz <224748+Luckz@users.noreply.github.com>

Signed-off-by: Luckz <224748+Luckz@users.noreply.github.com>

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.