confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

Поиск
Список
Период
Сортировка
От Atul Kumar
Тема confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
Дата
Msg-id CA+ONtZ62CK2mu75N9A3zzqQ_mffoHaRPiQit11xMTF2OC_zYGA@mail.gmail.com
обсуждение исходный текст
Ответы Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay  (Ron <ronljohnsonjr@gmail.com>)
Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Hi,

Could someone help me in telling the difference between these three parameters 
1. max_standby_archive_delay
2. max_standby_streaming_delay
3. recovery_min_apply_delay

My basic motive is to make the standby database server to be delayed to apply the changes on itself,  if any data has been accidentally deleted/updated/ truncated from the primary server.

Which parameter do I need to configure to serve this purpose ? And 
When will the remaining two parameters be used ?

It would be great if anyone can explain them with a brief example.



Regards.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: only immutable functions supported in continuous aggregate view
Следующее
От: Ron
Дата:
Сообщение: Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay