Re: pg_ls_waldir does not work on standy

Postgres version is 10.12

On Mon, Dec 12, 2022 at 6:51 PM Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
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
>