Package: prometheus-postgres-exporter Version: 0.15.0-2 Severity: normal Dear Maintainer,
Despinte executing sql statements in /usr/share/doc/prometheus-postgres-exporter/README.Debian I'm observing following errors in the porstresql (16) log files: 2024-03-21 06:52:38.383 UTC [56394] prometheus@postgres ERROR: permission denied for function pg_ls_waldir 2024-03-21 06:52:38.383 UTC [56394] prometheus@postgres STATEMENT: SELECT COUNT(*) AS segments, SUM(size) AS size FROM pg_ls_waldir() WHERE name ~ '^[0-9A-F]{24}$' I think additional permissions are needed for prometheus sql user, however I'm unsure what is the best and safest way to grant them to the monitoring user. -- System Information: Debian Release: trixie/sid APT prefers unstable APT policy: (500, 'unstable') Architecture: amd64 (x86_64) Kernel: Linux 6.6.13-amd64 (SMP w/4 CPU threads; PREEMPT) Locale: LANG=pl_PL.UTF-8, LC_CTYPE=pl_PL.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages prometheus-postgres-exporter depends on: ii adduser 3.137 ii init-system-helpers 1.66 ii libc6 2.37-15.1 ii systemd-sysv 255.4-1+b1 prometheus-postgres-exporter recommends no packages. prometheus-postgres-exporter suggests no packages.