Re: patroni recovery_min_apply_delay parameter

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: mustafa(dot)pekgoz(at)forenda(dot)com(dot)tr, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: patroni recovery_min_apply_delay parameter
Date: 2021-06-08 01:19:36
Message-ID: ba637bb4c8733968729fe0bec9679618589ab4ab.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 2021-06-07 at 17:58 +0300, mustafa(dot)pekgoz(at)forenda(dot)com(dot)tr wrote:
> I have patroni cluster with 1 leader and 2 replica but I want to change recovery_min_apply_delay
> parameter for one replica database, is it possible to change the parameter without creating another scope or DCS?
> Could you please share an example patrani yml file if it is possible

Not sure if Patroni overrides that parameter, but you could simply set that
parameter in the YAML file just like any other PostgreSQL parameter.

It might be a good idea to set "nofailover: true" for that node.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Don Seiler 2021-06-09 16:41:52 Estimating HugePages Requirements?
Previous Message Ron 2021-06-07 17:11:10 Re: Automate pg_basebackup in linux