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.
