pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpatroni recovery_min_apply_delay parameter
2+ messages / 2 participants
[nested] [flat]
* patroni recovery_min_apply_delay parameter
@ 2021-06-07 14:58 mustafa.pekgoz@forenda.com.tr
2021-06-08 01:19 ` Re: patroni recovery_min_apply_delay parameter Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 2+ messages in thread
From: mustafa.pekgoz@forenda.com.tr @ 2021-06-07 14:58 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello,
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
Saygýlarýmla.
---
Mustafa Pekgöz
Co-Founder, Principal Database Consultant
Tel : +90 534 429 76 83
E-mail : <mailto:mustafa.pekgoz@forenda.com.tr>
mustafa.pekgoz@forenda.com.tr
Website: <http://www.forenda.com.tr/; www.forenda.com.tr
Adres : Barbaros Mah. Begonya Sok. Nidakule No: 1/2 Batý Ataþehir / ÝSTANBUL
Attachments:
image003.png (image/png, 2.9K) download
view image
image001.jpg (image/jpeg, 3.3K) download
view image
* Re: patroni recovery_min_apply_delay parameter
2021-06-07 14:58 patroni recovery_min_apply_delay parameter mustafa.pekgoz@forenda.com.tr
@ 2021-06-08 01:19 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2021-06-08 01:19 UTC (permalink / raw)
To: mustafa.pekgoz@forenda.com.tr; pgsql-admin@lists.postgresql.org
On Mon, 2021-06-07 at 17:58 +0300, mustafa.pekgoz@forenda.com.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-06-08 01:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-07 14:58 patroni recovery_min_apply_delay parameter mustafa.pekgoz@forenda.com.tr
2021-06-08 01:19 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox