Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vO9vo-00Ca1x-2w for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 07:27:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vO9vn-00EtZL-1n for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 07:27:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vO9vn-00EtZC-0n for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 07:27:15 +0000 Received: from mail-lf1-x12a.google.com ([2a00:1450:4864:20::12a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vO9vl-001X0k-0n for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 07:27:14 +0000 Received: by mail-lf1-x12a.google.com with SMTP id 2adb3069b0e04-595819064cdso828975e87.0 for ; Tue, 25 Nov 2025 23:27:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764142032; x=1764746832; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=ARzjW63peOrgfMEY4Izg7sxGyfxatXOLwJroePNbU0I=; b=Cfs6iJPpwd1siSGUZlxeVex7hWrFFTl4tqfyqrGTGisdm2AERmAei1jNCvXhcgmZTL PJexmpEGguu5V+4Cbr6i3u6V2O42rFk+HhPcoP8mnq55pddfpotGmJe3grqnKBKNKR1t xoypcC/qRS02qOdUSy2HKYyoL7oSBiOeRWYEpe/MPq+Sz0+tvzPgWP+YpJZ+r21YC+V0 IeoIh57MR9y3h9Pkwhz52njDAfV/Klfw5DCZydQifVOlauxKpQjo+TngldDBm2X/Fbsc 0cf0sbJ49mHU1nqIi6z1sJLIG/6M3JJvkjqBnc8rZJlF5z7RJTjVp0RTBZOLH7VGJKt6 566g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764142032; x=1764746832; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-gg:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=ARzjW63peOrgfMEY4Izg7sxGyfxatXOLwJroePNbU0I=; b=eOfOeCPZrKaDzmRMsSuIDt4GrC7m4ppe2yzfbTUjZA+SypWcX1zGJAKkBvBZS+I+5a 7076jXctXkfwJLd2jul88TZgUTx26kdoN/BJKG/r1OMdG59mHJTqPvj665w/RnUubtw4 KXQJDloF5snRgu4oXk3EUkBiZQFzUMFBCg5WBXPC0YJ5bslj1stHXxEBkH3Pqr70E4Sj xnU/GQSac0+h8DHwetIhzGU/IOgIp1SQ6UJ486Jo92TvSLIng6JBRDscKazV1fSH46cE paq6ftbrWah1doSwgU/7xbJjGb/3/7dNuH1a79Dn9T1Uym3Ldqvqq4+ACWsEEMfuOm8j llNg== X-Gm-Message-State: AOJu0YzFvKMErxzFHunWRJG+4/rbPdGzlQUYFszKOfxXLfEKD41SD8YA xvhwjlCxK7iz64276BilXG0kTVubNSwEMN4ZfSPt6NL1EUiHMY/g100KyL599DGj9uk= X-Gm-Gg: ASbGncv4gaBZfb6A/1GceCi2nuT/Kg8tkh6tgbUWT6UZRcAZ+qj2KWuOd/xkX6NwxQG UB5C76AXEiKwXlkPSSxTJ0pnJokSgkSDKuxMIczNVXcpYfL0ayArinA0zHiIpo4UTi50AyI+Me1 Eupwt/71AyqrNErFyCJCEtHyA2yNhqf3u52z/OPSEbSf0XRBVyURmPzXhOcCkZR1D5RYXXt/auv tDHwyCSfOKAastpU9wnnhh3L8EJh0/vVd+DuL5FV2Ma19j5nZoDLrmT9NMF05m0pYLI95zNCuta 2xKy05dEhAoW/14U7e+KueDbzyuoQvAAmxuv796TNMMobl9Zt3gm8vSQgrKvsMMR+VXGLC1Jl9A EOhbldsQtcAfFJxBBPTBNU8ZUIHyaycG7p+RgnyfaTInx9x4lG1DA4+GRgrpPvqHx4aLIKmpJaS SanjRTcg+bPNkidsUWtenaOdCE0sZGNfISm3Rq+aaCQJpiFRFCTFE6tN+mYUDZwZqr/g== X-Google-Smtp-Source: AGHT+IEl4BnT2Ar4xloU78bJo14VW/Prs/1I1n37XoOwWXUL3hNqw+j7zEzjPD+rCes7WxDrcYlkAQ== X-Received: by 2002:ac2:4f03:0:b0:596:b1bd:cbe4 with SMTP id 2adb3069b0e04-596b1bdcd6cmr2747671e87.8.1764142031842; Tue, 25 Nov 2025 23:27:11 -0800 (PST) Received: from smtpclient.apple (83-233-125-94.cust.bredband2.com. [83.233.125.94]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-5969db74711sm5807494e87.12.2025.11.25.23.27.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 25 Nov 2025 23:27:11 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Andrew Mime-Version: 1.0 (1.0) Subject: Re: Wal streaming Date: Wed, 26 Nov 2025 08:27:00 +0100 Message-Id: References: <4b91a533-b2b7-42fe-bfb7-d92d56c6c1c1@aklaver.com> Cc: pgsql-general@lists.postgresql.org In-Reply-To: <4b91a533-b2b7-42fe-bfb7-d92d56c6c1c1@aklaver.com> To: Adrian Klaver X-Mailer: iPhone Mail (23B85) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I=E2=80=99m using Postgres 17 and the latest versions of repmgr and barman 1. I=E2=80=99m replicating my database to another node using streaming repli= cation. wal_level=3Dreplica, hot_standby=3Don.=20 2. I=E2=80=99ve got barman running on the primary node locally and have setu= p the barman config for streaming replication using streaming archiver and b= ackup method Postgres. Previous to this I was using the archive and restore c= ommands in postgresql.conf to use barman-wal-archive|restore to copy the wal= files to barman=E2=80=99s wal folder.=20 3. Barman is on node 1 where the primary is running. The replica database us= ed by repmgr is on node 2.=20 4. My archive command is still configured to use barman-wal-archive despite h= aving moved to a streaming replication method in barman.=20 So my question is, can I disable the archive command now that I am using str= eaming? Regards Andrew Sent from my iPhone > On 25 Nov 2025, at 16:54, Adrian Klaver wrote:= >=20 > =EF=BB=BFOn 11/25/25 05:46, Andrew wrote: >> Hi, >> New to the list. If I=E2=80=99m Using streaming archiving with repmgr, an= d streaming archiving with barman, do I still need to maintain my archive co= mmand, and have processes in place to delete archived wals periodically? Or= are they in effect defunct due to wal retention policies within Postgres? >=20 > You are going to need to expand on this as it is unclear to me what your p= rocesses are. >=20 > 1) What is the repmgr setup for streaming? >=20 > 2) What is the Barman setup for streaming? >=20 > 3) What locations are 1 & 2 streaming to? >=20 > 4) What is the process you have in place now to prune the archives? >=20 > 5) What are the Postgres version you are working with? >=20 >> Regards >> Andrew >> Sent from my iPhone >=20 >=20 > -- > Adrian Klaver > adrian.klaver@aklaver.com