From 7e49245fddcd16de615814781a3e52038ca219d9 Mon Sep 17 00:00:00 2001 From: Gabriel Arakaki Giovanini Date: Thu, 20 Jul 2023 18:10:26 +0200 Subject: chore: Remove added package Some package were added to the 3.18 and no longer need to be here. --- apks/prometheus-postgres-exporter/README.Alpine | 48 ------------------------- 1 file changed, 48 deletions(-) delete mode 100644 apks/prometheus-postgres-exporter/README.Alpine (limited to 'apks/prometheus-postgres-exporter/README.Alpine') 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; -- cgit v1.2.3