I've setup a master / slave Postgresql (13.4) group, 1 master and 1 slave, using WAL warm standby.
(refer: postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP)

But, due to some reason, the slave is out of sync for a while, then due to the WAL file not exists anymore on the master, the slave can't sync anymore.

A. Is there anyway to recover the slave, to get back to sync ?
B. Or is there anyway to re-create the slave without stop the running master?

Either A or B is acceptable.


Source link