Hi,We see below error when running the function on a standby instancepostgres=# SELECT * FROM pg_ls_waldir() postgres-# ;ERROR: could not stat directory "pg_wal": No such file or directoryIt works on a primary instanceListing log directory works in both primary and standbypostgres=# select * from pg_ls_logdir(); name | size | modification -------------------------+-----------+------------------------ postgresql-Fri.log | 274856244 | 2022-12-10 00:00:00+00 postgresql-Sat.log | 272873161 | 2022-12-11 00:00:00+00 postgresql-Thu.log | 274696376 | 2022-12-09 00:00:00+00Thanks,Nikhil
postgres=# SELECT * FROM pg_ls_waldir()
postgres-# ;
ERROR: could not stat directory "pg_wal": No such file or directory
It works on a primary instance
Listing log directory works in both primary and standby
postgres=# select * from pg_ls_logdir();
name | size | modification
-------------------------+-----------+------------------------
postgresql-Fri.log | 274856244 | 2022-12-10 00:00:00+00
postgresql-Sat.log | 272873161 | 2022-12-11 00:00:00+00
postgresql-Thu.log | 274696376 | 2022-12-09 00:00:00+00
Thanks,
Nikhil
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных