Bug#1067405: ERROR: permission denied for function pg_ls_waldir

[Daniel Swarbrick]

The instructions in README.Debian are outdated and need to be refreshed 
for currently supported Postgres versions (>= 10).


Please consult the /upstream/ documentation, specifically 
https://github.com/prometheus-community/postgres_exporter?tab=readme-ov-file#running-as-non-superuser, 
i.e. grant the "pg_monitor" role to your user.





OpenPGP_signature.asc
Description: OpenPGP digital signature

Bug#1067405: ERROR: permission denied for function pg_ls_waldir

[Skibbi]

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  libc62.37-15.1
ii  systemd-sysv 255.4-1+b1

prometheus-postgres-exporter recommends no packages.

prometheus-postgres-exporter suggests no packages.