pg_ls_waldir does not work on standy

From: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: pg_ls_waldir does not work on standy
Date: 2022-12-12 13:21:43
Message-ID: CAFpL5VxpPTroHqS1xP6TdMEvah4nK6LVJuA7mbdmk1fU0=Kdow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mladen Gogala 2022-12-12 13:26:48 Re: How to speed WAL apply in destination
Previous Message Raghvendra Choudhary 2022-12-12 11:40:50 Re: How to speed WAL apply in destination