MIME-Version: 1.0
References: <b29d24290aad4b49b2bdd73259e528d0@nrc-cnrc.gc.ca>
In-Reply-To: <b29d24290aad4b49b2bdd73259e528d0@nrc-cnrc.gc.ca>
From: Tim Gerber <tggerber@gmail.com>
Date: Tue, 23 Sep 2025 09:44:42 -0500
Message-ID: 
 <CAPKih1yy+ZTj=PHP72pgu283AP6WEH4FdoaHxrN5+1e7GtWBfw@mail.gmail.com>
Subject: Re: pgbackrest wiht arcchive mode off /no PITR configuration
To: "Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>
Cc: PGSQL ADMIN <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009e9f33063f78fa88"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPKih1yy%2BZTj%3DPHP72pgu283AP6WEH4FdoaHxrN5%2B1e7GtWBfw%40mail.gmail.com>
Precedence: bulk

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

If you aren't going to have archive_mode on, why not just
use pg_basebackup?  Not backing up archivelogs kind of defeats the purpose
of using pgbackrest in my opinion.

Best Regards,
Tim

On Tue, Sep 23, 2025 at 9:34=E2=80=AFAM Ghiurea, Isabella <
Isabella.Ghiurea@nrc-cnrc.gc.ca> wrote:

> Hi List.
> I have a requirement to use pgabackrest to run ONLY full backups with no
> need need for PITR in PG cluster 17.5
>
> I tried several configuration options seems that archive_mode can not be
> set to "off" for pgbackrest to run,  is this correct ?
>
>
> I tried unsuccessfully : archive_mode =3D on with
> archive_command =3D '/bin/true'
>
> Second unsuccessfully configuration : archive_mode =3Don with
> archive_command=3D'cp %p /tmp/pgbackrest-archive/%f'
>
>
> Can you suggest a working solution for my requirements ?
>
>

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

<div dir=3D"ltr">If you aren&#39;t going to have archive_mode on, why not j=
ust use=C2=A0pg_basebackup?=C2=A0 Not backing up archivelogs=C2=A0kind of d=
efeats the purpose of using pgbackrest in my opinion.=C2=A0<div><br></div><=
div>Best Regards,</div><div>Tim</div></div><br><div class=3D"gmail_quote gm=
ail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Sep 23, =
2025 at 9:34=E2=80=AFAM Ghiurea, Isabella &lt;<a href=3D"mailto:Isabella.Gh=
iurea@nrc-cnrc.gc.ca">Isabella.Ghiurea@nrc-cnrc.gc.ca</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg67156=
20963472311887">


<div dir=3D"ltr">
<div id=3D"m_6715620963472311887divtagdefaultwrapper" style=3D"font-size:12=
pt;color:rgb(0,0,0);font-family:Calibri,Helvetica,sans-serif" dir=3D"ltr">
<p></p>
<div>
<div>
<p dir=3D"auto">Hi List.<br>
I have a requirement to use pgabackrest to run ONLY full backups with no ne=
ed need for PITR in PG cluster 17.5<br>
</p>
<p dir=3D"auto">I tried several configuration options seems that archive_mo=
de can not be set to &quot;off&quot; for pgbackrest to run,=C2=A0 is this c=
orrect ?</p>
<p dir=3D"auto"><br>
</p>
<p dir=3D"auto">I tried unsuccessfully : archive_mode =3D on with<br>
archive_command =3D &#39;/bin/true&#39;</p>
<p dir=3D"auto">Second unsuccessfully configuration : archive_mode =3Don wi=
th<br>
archive_command=3D&#39;cp %p /tmp/pgbackrest-archive/%f&#39;</p>
<p dir=3D"auto"><br>
</p>
<p dir=3D"auto">Can you suggest a working solution for my requirements ?</p=
>
</div>
</div>
<br>
<p></p>
</div>
</div>

</div></blockquote></div>

--0000000000009e9f33063f78fa88--