pg_ls_waldir does not work on standy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux