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 |