Hi,
I have a doubt, assume that I have 3 psql10 nodes (n1, n2, n3) and n1 is master ,n2+n3 are standbys. In n1 archive mode is on, and wal_logs are going to volume which is shared with n2 and n3. If archive_cleanup_command = 'pg_archivecleanup /path/to/nfs %r' is enabled on both n2 and n3.
Can a situation might arise that a wal segment required by n2 is already cleaned up by n3?
If yes, then how to mitigate it?
Thanks!
Prince Pathria
Systems Architect
Evive
+91 9478670472
goevive.com