pg_ls_waldir does not work on standy - Mailing list pgsql-admin

From Nikhil Shetty
Subject pg_ls_waldir does not work on standy
Date
Msg-id CAFpL5VxpPTroHqS1xP6TdMEvah4nK6LVJuA7mbdmk1fU0=Kdow@mail.gmail.com
Whole thread Raw
Responses Re: pg_ls_waldir does not work on standy  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Raghvendra Choudhary
Date:
Subject: Re: How to speed WAL apply in destination
Next
From: Mladen Gogala
Date:
Subject: Re: How to speed WAL apply in destination