aboutsummaryrefslogtreecommitdiff
path: root/apks/prometheus-postgres-exporter/README.Alpine
diff options
context:
space:
mode:
authorGabriel Arakaki Giovanini <mail@gabrielgio.me>2023-07-20 18:10:26 +0200
committerGabriel Arakaki Giovanini <mail@gabrielgio.me>2023-07-20 18:10:26 +0200
commit7e49245fddcd16de615814781a3e52038ca219d9 (patch)
tree07e2fe3059f9a7b79abeee3fcde2cc387eda2077 /apks/prometheus-postgres-exporter/README.Alpine
parent9e9b54b503cea89b9c776c6eb65deef16682c1d2 (diff)
downloadapkbuilds-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.Alpine48
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;