diff options
author | Gabriel Arakaki Giovanini <mail@gabrielgio.me> | 2023-07-20 18:10:26 +0200 |
---|---|---|
committer | Gabriel Arakaki Giovanini <mail@gabrielgio.me> | 2023-07-20 18:10:26 +0200 |
commit | 7e49245fddcd16de615814781a3e52038ca219d9 (patch) | |
tree | 07e2fe3059f9a7b79abeee3fcde2cc387eda2077 /apks/prometheus-postgres-exporter/README.Alpine | |
parent | 9e9b54b503cea89b9c776c6eb65deef16682c1d2 (diff) | |
download | apkbuilds-7e49245fddcd16de615814781a3e52038ca219d9.tar.gz apkbuilds-7e49245fddcd16de615814781a3e52038ca219d9.tar.bz2 apkbuilds-7e49245fddcd16de615814781a3e52038ca219d9.zip |
chore: Remove added package
Some package were added to the 3.18 and no longer need to be here.
Diffstat (limited to 'apks/prometheus-postgres-exporter/README.Alpine')
-rw-r--r-- | apks/prometheus-postgres-exporter/README.Alpine | 48 |
1 files changed, 0 insertions, 48 deletions
diff --git a/apks/prometheus-postgres-exporter/README.Alpine b/apks/prometheus-postgres-exporter/README.Alpine deleted file mode 100644 index 6e09049..0000000 --- a/apks/prometheus-postgres-exporter/README.Alpine +++ /dev/null @@ -1,48 +0,0 @@ -This document is adapted from README.Debian contained in Debian package. - -To use the PostgreSQL exporter, you need to connect to the database with -superuser (postgres) privileges, or with an user that has been granted enough -permissions. - -The recommended way to do this, is to create a `prometheus` user with no -password, and then connect using UNIX domain sockets. - -To do that, set this connection string in -/etc/conf.d/prometheus-postgres-exporter: - - DATA_SOURCE_NAME='user=prometheus host=/run/postgresql dbname=postgres' - -And use psql (doas -u postgres psql) to execute these SQL commands to create -the user: - - CREATE USER prometheus; - ALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog; - - CREATE SCHEMA prometheus AUTHORIZATION prometheus; - - CREATE FUNCTION prometheus.f_select_pg_stat_activity() - RETURNS setof pg_catalog.pg_stat_activity - LANGUAGE sql - SECURITY DEFINER - AS $$ - SELECT * from pg_catalog.pg_stat_activity; - $$; - - CREATE FUNCTION prometheus.f_select_pg_stat_replication() - RETURNS setof pg_catalog.pg_stat_replication - LANGUAGE sql - SECURITY DEFINER - AS $$ - SELECT * from pg_catalog.pg_stat_replication; - $$; - - CREATE VIEW prometheus.pg_stat_replication - AS - SELECT * FROM prometheus.f_select_pg_stat_replication(); - - CREATE VIEW prometheus.pg_stat_activity - AS - SELECT * FROM prometheus.f_select_pg_stat_activity(); - - GRANT SELECT ON prometheus.pg_stat_replication TO prometheus; - GRANT SELECT ON prometheus.pg_stat_activity TO prometheus; |