I have postgresql master server and a standby server. The standby will be in recovery mode(ie. will be consuming the wals shipped from the master node). The master will be read/write and the standby will not be able to query until its promoted(DR setup).
I wanted to know the replication status of the standby node(ie. Each wals restored in standby with time to time).
Version - postgresql 12.3
OS - centos 8
Also is it possible to use streaming replication along with wal file shipping.