Обсуждение: Archive param questions?

Поиск
Список
Период
Сортировка

Archive param questions?

От
Murthy Nunna
Дата:

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