confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
Date: 2023-03-11 20:23:44
Message-ID: CA+ONtZ62CK2mu75N9A3zzqQ_mffoHaRPiQit11xMTF2OC_zYGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-03-11 20:54:18 Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay
Previous Message Tom Lane 2023-03-11 15:47:52 Re: ERROR: only immutable functions supported in continuous aggregate view