Re: pg_ls_waldir does not work on standy

[Nikhil Shetty <nikhil.dba04@xxxxxxxxx>]

Postgres version is 10.12

On Mon, Dec 12, 2022 at 6:51 PM Nikhil Shetty <nikhil.dba04@xxxxxxxxx> wrote:

Hi,

We see below error when running the function on a standby instance

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