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.

Reply via email to