Thread: finding and monitoring old WAL archives

finding and monitoring old WAL archives

From
asli cokay
Date:
Hi everyone ,

I want to ask that let's say if I have 1 day old wal files I want to figure out and monitor that with prometheus. 

I can find the WAL files in this way  find <path to wal> -ctime +x(day)

I wonder if I want to figure out the files with sql command is there any way to figure out ?

Thanks in advance.