Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lqQPA-0004Np-EO for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jun 2021 01:19:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lqQP8-0003nB-SR for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jun 2021 01:19:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lqQP8-0003n2-AV for pgsql-admin@lists.postgresql.org; Tue, 08 Jun 2021 01:19:42 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lqQP5-0003nO-5t for pgsql-admin@lists.postgresql.org; Tue, 08 Jun 2021 01:19:40 +0000 Received: by mail-wr1-x434.google.com with SMTP id f2so19571924wri.11 for ; Mon, 07 Jun 2021 18:19:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=/nPlAYgnf1Zd/VottGv19HZrhb4DYEHrCUsEJvvoceo=; b=zWvRoYVE6mlsgV6Z2080asmPjE4lXJr/7QVPZgD+5qtOGDpxIGu0ObNF6cf0t4yEP9 6l7aaRfEjo0pVxsw478pFN6LiFLvEpS0dkVZliH3R/6VGG/6yMolwXG4QEeUKfqwy9rq XFs4WCk1BTe/NFxWKSkUupDHBS3qeYE4r+RdElxWAOKHxi+eJ4c3vEh9U1ZUHFMaBNwx 0FwJ7/wAZNJHKbOH3JbR66JC/ae14BpsqyvBxBUw0tAbMWVNMNJYYMz3eX+dqhfxmWdC aoGIv/W0/yIPDFpjNaoxmN+XGQP3+zrUJvWX7Gb9D8r2JSNUSRhl/gMmaQkNRMnR4mMa GxAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=/nPlAYgnf1Zd/VottGv19HZrhb4DYEHrCUsEJvvoceo=; b=Ffv+E3loThuDV0ShpBnZSpcKn/8xJr1c8oFTDAu/CxiGT9T1p2OsIKYVizYxmkEXEb dTzv0bkqWM0x661hJXlE9q9pxU7GrEuZCKejMtmJ4XPjxi9cLO9CImcNwjDrsCsRgNvh ehpnND3AWgjXbjSAVmGC4x+CeKy2sn7PQyZLKeQ0HgKV//QjTzP/nXmMmjLwU1dGynfA qlweKhpTlItqrHQFYyprUwa560lvS4fMQNvs1eKyGt1ZfCn8BZoLV/ChhPW3dCTiT1RD jnnlSbLsfTvfLG9enN2kVLnc1cdifHA8M4lxNHW4rZ9sGUs5r0GSQaiZq0L5Cjm9X9dk rmkQ== X-Gm-Message-State: AOAM533HyAVpNqavboHGIuY+Jx6qO+DjuPb2y8PzwenJ5DHik3mR3pck v6ysoaROnc09NTbcWHDEXPgrP02rur2/fg== X-Google-Smtp-Source: ABdhPJxvcXj6ikHYpqZbJs2cNFcYIBt0ZJf4T45mwgSUmeUffuxGhNPCYgak9ekvifAagWKTt58nZQ== X-Received: by 2002:adf:a550:: with SMTP id j16mr19974122wrb.25.1623115177139; Mon, 07 Jun 2021 18:19:37 -0700 (PDT) Received: from localhost.localdomain (178-190-172-55.adsl.highway.telekom.at. [178.190.172.55]) by smtp.gmail.com with ESMTPSA id b26sm1039623wmj.25.2021.06.07.18.19.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 07 Jun 2021 18:19:36 -0700 (PDT) Message-ID: Subject: Re: patroni recovery_min_apply_delay parameter From: Laurenz Albe To: mustafa.pekgoz@forenda.com.tr, pgsql-admin@lists.postgresql.org Date: Tue, 08 Jun 2021 03:19:36 +0200 In-Reply-To: <008f01d75bad$938892b0$ba99b810$@forenda.com.tr> References: <008f01d75bad$938892b0$ba99b810$@forenda.com.tr> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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