I have PostgreSQL streaming replication setup using replication slot. Node1 is primary and Node2 is slave. Now, node1 is down and promoted node2. Node2 is running and in read-write mode. There is heavy load on node2 now. How i can make sure enough WALs getting preserved on node2, so that when node1 joins, it could do diff sync using pg_rewind
. This is PostgreSQL 14. There is no WAL archiving setup.
adding replication tag and also transaction log tag