MIME-Version: 1.0
References: <4b91a533-b2b7-42fe-bfb7-d92d56c6c1c1@aklaver.com>
 <D99EB7AB-72F7-4769-BE90-92ED6F77AAFF@gmail.com> <95c0ba97-f427-4a4b-8e18-67c1ba3a60fd@aklaver.com>
In-Reply-To: <95c0ba97-f427-4a4b-8e18-67c1ba3a60fd@aklaver.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 26 Nov 2025 14:46:33 -0500
Message-ID: <CANzqJaDFY_kTUu-MKgdQ+mLhPwBmdoD1gn1-rQ-=RUzyrVmkjg@mail.gmail.com>
Subject: Re: Wal streaming
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f232d4064484a7d2"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDFY_kTUu-MKgdQ%2BmLhPwBmdoD1gn1-rQ-%3DRUzyrVmkjg%40mail.gmail.com>
Precedence: bulk

--000000000000f232d4064484a7d2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Nov 26, 2025 at 2:26=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> On 11/25/25 23:27, Andrew wrote:
> > Hi,
> >
> > I=E2=80=99m using Postgres 17 and the latest versions of repmgr and bar=
man
> >
> > 1. I=E2=80=99m replicating my database to another node using streaming
> replication. wal_level=3Dreplica, hot_standby=3Don.
> > 2. I=E2=80=99ve got barman running on the primary node locally and have=
 setup
> the barman config for streaming replication using streaming archiver and
> backup method Postgres. Previous to this I was using the archive and
> restore commands in postgresql.conf to use barman-wal-archive|restore to
> copy the wal files to barman=E2=80=99s wal folder.
> > 3. Barman is on node 1 where the primary is running. The replica
> database used by repmgr is on node 2.
> > 4. My archive command is still configured to use barman-wal-archive
> despite having moved to a streaming replication method in barman.
> >
> > So my question is, can I disable the archive command now that I am usin=
g
> streaming?
>
> I am not going to straight up say you can disable the archive command as
> I will not be the one that has to bear the consequences.
>
> What I will say:
>
> 1) Have you tested that the Barman, repmgr setups work to do a recovery?
>
> 2) Are the two archive processes(streaming replication,
> barman-wal-archive) going to different locations?
>
> 3) There is also the question of whether the two archive methods are in
> sync. In other words would you get the same restore if used either at
> some point in time?
>
> My personal opinion is you would be best served by having only one
> tested process working.
>

I wonder if a non-streaming backup program like pgbackrest would simplify
things.  It would eliminate one stream, and remove the need to manage the
wal archive (since pgbr does all that for you in its own separate
repository).

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000f232d4064484a7d2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Nov 26, 2025 at 2:26=E2=80=AFPM A=
drian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver=
@aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_cont=
ainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex">On 11/25/25 23:27,=
 Andrew wrote:<br>
&gt; Hi,<br>
&gt; <br>
&gt; I=E2=80=99m using Postgres 17 and the latest versions of repmgr and ba=
rman<br>
&gt; <br>
&gt; 1. I=E2=80=99m replicating my database to another node using streaming=
 replication. wal_level=3Dreplica, hot_standby=3Don.<br>
&gt; 2. I=E2=80=99ve got barman running on the primary node locally and hav=
e setup the barman config for streaming replication using streaming archive=
r and backup method Postgres. Previous to this I was using the archive and =
restore commands in postgresql.conf to use barman-wal-archive|restore to co=
py the wal files to barman=E2=80=99s wal folder.<br>
&gt; 3. Barman is on node 1 where the primary is running. The replica datab=
ase used by repmgr is on node 2.<br>
&gt; 4. My archive command is still configured to use barman-wal-archive de=
spite having moved to a streaming replication method in barman.<br>
&gt; <br>
&gt; So my question is, can I disable the archive command now that I am usi=
ng streaming?<br>
<br>
I am not going to straight up say you can disable the archive command as <b=
r>
I will not be the one that has to bear the consequences.<br>
<br>
What I will say:<br>
<br>
1) Have you tested that the Barman, repmgr setups work to do a recovery?<br=
>
<br>
2) Are the two archive processes(streaming replication, <br>
barman-wal-archive) going to different locations?<br>
<br>
3) There is also the question of whether the two archive methods are in <br=
>
sync. In other words would you get the same restore if used either at <br>
some point in time?<br>
<br>
My personal opinion is you would be best served by having only one <br>
tested process working.<br></blockquote><div>=C2=A0</div><div>I wonder if a=
 non-streaming backup program like pgbackrest would simplify things.=C2=A0 =
It would eliminate one stream, and remove the need to manage the wal archiv=
e (since pgbr does all that for you in its own separate repository).</div><=
/div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><d=
iv dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Reda=
cted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br>=
<div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--000000000000f232d4064484a7d2--