ERROR: permission denied for function pg_ls_waldir

Description:

Not really an issue but, after having installed pmm i see, every 5 seconds, on logs
…/pmm-data/_data/logs/postgresql14.log

ERROR: permission denied for function pg_ls_waldir every 5 seconds

Steps to Reproduce:

installed pmm percona/pmm-server on Docker with volume

Version:

2fcec986e0f0 percona/pmm-server:2

Logs:

2024-01-24 09:52:27.996 UTC [3574] ERROR: permission denied for function pg_ls_waldir
2024-01-24 09:52:27.996 UTC [3574] STATEMENT:
SELECT
COUNT() AS segments,
SUM(size) AS size
FROM pg_ls_waldir()
WHERE name ~ ‘[1]{24}$’
2024-01-24 09:52:33.009 UTC [3588] ERROR: permission denied for function pg_ls_waldir
2024-01-24 09:52:33.009 UTC [3588] STATEMENT:
SELECT
COUNT(
) AS segments,
SUM(size) AS size
FROM pg_ls_waldir()
WHERE name ~ ‘[2]{24}$’

Expected Result:

Actual Result:

Additional Information:


  1. 0-9A-F ↩︎

  2. 0-9A-F ↩︎

Hi,
We are aware of this problem and it will be fixed in 2.41.1

Thanks

1 Like