Can someone please enlighten me or point me to the documentation?
1. What is the role of “archive” and “archive_command” in a slave that is directly fed from master in a simple primary->slave configuration? I want to know both cases where archive = on versus archive = off and their relation to other parameters such as hot_standby.
2. Similarly what is the role of above two settings in a cascading standby? (cascading standby per documentation is defined as the slave that feeds another slave in a cascade configuration). I am talking about slave1 in a primary->slave1->slave2 cascade configuration.
I truly appreciate your responses.
Thanks,
Murthy