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.


You can ask primary server about replication status of standby server(s) by using pg_stat_replication which is a system statistics view.

You can use WAL Archiving to setup a replication instead of / in addition to streaming replication

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy