Commit Graph

54 Commits

Author SHA1 Message Date
Will Rouesnel 178426c095
Merge branch 'master' into feature/test_postgres_12 2021-01-31 22:23:07 +11:00
Ajay Bhat c55a3b3c5b
Fixes (#364) (#387)
Have a custom prefix for each of the default metrics created by postgres_exporter

Co-authored-by: Will Rouesnel <wrouesnel@wrouesnel.com>
2020-12-25 02:36:18 +11:00
Will Rouesnel 69e1ec9829
Merge branch 'master' into feature/test_postgres_12 2020-12-25 02:23:44 +11:00
Robbie Trencheny a7538454ed
Add pg_stat_statements view for non-superuser instructions (#398) 2020-08-28 10:03:23 +10:00
Will Rouesnel 28ba87da97
Merge branch 'master' into feature/test_postgres_12 2020-08-28 10:02:42 +10:00
Lars Kellogg-Stedman 77d42931d0
update docs with examples of DATA_SOURCE_URI (#378)
this has a minor change to the wording and a couple of examples to demonstrate
the use of DATA_SOURCE_URI.

Closes #113
2020-04-10 01:14:24 +10:00
Will Rouesnel 8ac2805369
Add postgres 12 to integration tests. 2020-02-25 13:20:33 +00:00
Vladimir N. Indik 75d542d496 Update "Flags" list in README (#331)
* Update README according --help output

* Update environment variables list in README
2019-11-20 10:19:34 +11:00
sfalkon deac1c37db fix master database behavior 2019-11-20 10:18:20 +11:00
Benjamin P. Jung 9b13f5ec57 Add support for 'DATA_SOURCE_URI_FILE' envvar.
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.
2019-11-20 10:17:31 +11:00
Will Rouesnel c2866fd2e2
Fix README.md. 2019-11-01 01:04:08 +11:00
Marcos A L M Macedo 27d5c9926d Add SQL for grant connect (#303)
To resolve the error below, it was necessary to add a new grant to the database postgres.

Error: 'pq: permission denied for database \ "postgres \"'
2019-10-30 14:58:17 +11:00
Alexis Sellier 1ab8d2bbc8 Discover only databases that are not templates and allow connections (#297)
* Discover only databases that are not templates and allow connections

* Update readme
2019-08-12 11:40:58 +10:00
Alexis Sellier c768e64548 Add --exclude-databases option (#298)
* Add exclude-databases option
* Update readme to explain --exclude-databases
* Add comments to ExcludeDatabases function and unexport Contains function
2019-08-12 11:25:01 +10:00
Sakis 1c14eb964a README: SQL that supports re-execution
Make the SQL work in automated deployments where it will be repeated many times.
2019-07-12 10:26:07 +10:00
Will Rouesnel 97554928e6
Update README.md 2019-07-03 22:37:58 +10:00
Arno Geurts 4d96104c10 Add documentation for auto-discover-databases 2019-07-03 22:17:15 +10:00
Asher Foa f9bb147ee8 Add badge for docker pulls. 2019-07-01 08:43:24 +10:00
Michael Kaye b12adc11e4 Update README.md
Allow non-superuser commands to be re-run without (some) errors.
2019-07-01 08:43:07 +10:00
Sean Corkum 07dd31dea6 Update README.md
add ; for any users that are copy/pasting from the readme
2019-06-15 19:39:39 +10:00
Asher Foa c9dc7a20a1 remove unsupported postgres versions 2019-06-15 19:38:40 +10:00
Freddy Spierenburg fce869257f Update the running as non-superuser section. This solves the problem that certain metrics didn't produce a value. 2019-02-20 23:37:10 +11:00
Anthony Regeda 1d6a733ba2 multi-server-exporter multi server exporter is introduced 2018-12-19 01:46:45 +11:00
Will Rouesnel fec1a171ba
Update README.md 2018-11-11 15:48:27 +11:00
Phil Frost 456ac72430 Document --constantLabels
This functionality was added in c225a1e194
but not documented.
2018-11-11 13:55:45 +11:00
Sylvain Rabot 844076cd6d Add dbname to example to avoid confusion 2018-11-03 01:23:54 +11:00
Samuel Barabas 265a2ea8eb Add info about PG_* env vars to README (#199) 2018-07-17 01:20:01 +10:00
Will Rouesnel 36e13ca8a5
Update README.md
Improve the documentation for `--disable-default-metrics` and update the listing of current flags.
2018-03-21 00:41:58 +11:00
Hang Sun f00c4b7b87 Added command-line flag to disable the default metrics 2018-03-21 00:28:59 +11:00
Will Rouesnel 989489096e Refactor repository layout and convert build system to Mage.
This commit implements a massive refactor of the repository, and
moves the build system over to use Mage (magefile.org) which should
allow seamless building across multiple platforms.
2018-03-06 07:29:35 +10:00
Joscha 3e6cf08dc5 In docker example both containers should run on the host net (#149)
* In docker example both containers should run on the host net 
* remove unecessary portmapping in docs
2018-02-20 18:27:58 +10:00
fjavierm 02718d0e26 Add a couple of pre-instructions to the README file for the build process. (#152) 2018-02-02 19:04:07 +10:00
Will Rouesnel 5b9fea01ee Add cross-compilation Makefile targets and tar-based releases.
Revamp the build system to be more inline with other Prometheus exporters.
Notably add Darwin and Windows build targets, and add support for releases
using tar files.
2017-11-30 13:17:13 +10:00
Chris Travers 8b4d70ae5f Removed unnecessary complexity in readme.md
In PostgreSQL, views run as the defining user, meaning you don't 
need a view wrapping a function (you can just have a view).  This 
improves readability, maintainability, performance, and clarity.
2017-10-26 20:01:59 +11:00
Will Rouesnel e3dbbe64fd Update README.md 2017-10-26 19:46:02 +11:00
Alexander Savchuk 81194c9219 Grant postgres_exporter role to deployer role
If the deployer role is not superuser (which is the case in AWS RDS,
for example), we need to grant it access to postgres_exporter role
before we can create a schema with AUTHORIZATION postgres_exporter.
2017-06-09 20:04:27 +10:00
Alexander Savchuk 1ec400b707 Fix PostgreSQL name
PostgreSQL name was misspelled in
53b9d9cea7.
2017-06-09 20:04:27 +10:00
Michał Czeraszkiewicz 53b9d9cea7 Improve "Running as non-superuser" documentation.
Closes #53 (rebased and merged).
2017-04-14 00:49:31 +10:00
Matt Bostock c7ac2b0e12 Make references to PostgreSQL consistent
While many pronounce it as 'post-GRES', the spelling is 'PostgreSQL' with two 's'.

https://www.postgresql.org/about/press/faq/
2017-03-04 02:56:35 +11:00
Will Rouesnel ff8e0c5382 Add coverage and code quality badges. 2017-02-25 01:18:27 +11:00
Will Rouesnel 8ec2d3d73c Remove the spurious config.expect-replication-stats option.
This was something that was going to be added but never materialized into a practical feature.
2016-11-29 07:44:38 +11:00
Mario Trangoni cd9bb8605e README.md: Update to new default port 9187 2016-11-21 09:50:15 +01:00
Will Rouesnel 175686dc0f Use the gocheck binary to run Postgres matrix tests. 2016-11-17 22:14:13 +11:00
Nick Cabatoff 64f5d9ac0f Document -extend.query-path in README. Add more examples to queries.yaml. 2016-09-07 15:15:52 -04:00
Will Rouesnel 66db8ebaa0 Update README.md for travis-build 2016-05-28 14:35:17 +10:00
Will Rouesnel c929bad6a1 README.md connection strings were wrong
Looks like lib/pq has updated their connection strings upstream so the URL parsing is more URL-like.
2016-05-20 19:04:31 +10:00
Will Rouesnel 4c8b9700c6 Merge branch 'local_changes' 2016-03-12 21:18:05 +11:00
Will Rouesnel 054d825c7d Vendor all dependencies, add docker build to makefile.
Vendor and store all dependencies. This allows us to have a makefile which
builds to a minimized docker image.
2016-03-12 21:16:17 +11:00
fiknytte 7e8fbdf07f Added support for collecting arbitrary sql queries.
Added metrics for locks per database per mode, pg_stat_activity, pg_stat_replication.
Updated README.md with possible solution for running as non-superuser.
2016-01-21 13:15:20 +01:00
Will Rouesnel c931b83b7c Update README.md
Update README with a workable connection string for local use.
2015-09-07 15:25:10 +10:00