MIME-Version: 1.0
References: <CAKgGyB8J1iJMzDuL5A-s9Y8x2O4FgFc_gwZYu_iTDbRquk94uw@mail.gmail.com>
In-Reply-To: <CAKgGyB8J1iJMzDuL5A-s9Y8x2O4FgFc_gwZYu_iTDbRquk94uw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 9 Oct 2025 09:49:34 -0400
Message-ID: <CANzqJaDwHOg23KsTA3Njr3aWRrOEs5RstjuYqV_vG0nWkTk+8Q@mail.gmail.com>
Subject: Re: Pgbackrest changing RepoServer to new one
To: KK CHN <kkchn.in@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000106d6a0640ba13bc"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDwHOg23KsTA3Njr3aWRrOEs5RstjuYqV_vG0nWkTk%2B8Q%40mail.gmail.com>
Precedence: bulk

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

On Thu, Oct 9, 2025 at 3:16=E2=80=AFAM KK CHN <kkchn.in@gmail.com> wrote:

> List,
>
> I am in need of changing Repo Server of an existing  working pgbackrest
> setup(RHEL 9.3  , pgbackrest 2.52.1  database version 16)
>
> *I have googled,  got the information  that I need to do *
>
> 1. First shutdown the   Postgre Server cluster/instance. ( This is a
> production server, downtime permissions required if need to do so)
>
> 2  stop the stanza  and delete the stanza
>
> 3. Then recreate the stanza with the same name from the new  Repo Server.
>
> In need to change the RepoServer due to the storage limitations on the
> RepoServer forced to move to a large Repo Server.
>
> Can I bypass the step1 ( shutdown the postgreserver ?) and do step 2 and
> step 3,  will this action stalemate the entire DB server and backup setup=
.
>
> Request your valuable guidance and advice.
>

repo entries in pgbackrest.conf are numbered.  "Just" add repo2-xxxx
entries to your existing pgbackrest.conf, and then add "--repo=3D2" to your
existing pgbackrest commands.

(That *should* work.  I've never had to try it.)

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Oct 9, 2025 at 3:16=E2=80=AFAM KK=
 CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com">kkchn.in@gmail.com</a>&gt; w=
rote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">List,<div><br></div><di=
v>I am in need of changing Repo Server of an existing=C2=A0 working pgbackr=
est setup(RHEL 9.3=C2=A0 , pgbackrest 2.52.1=C2=A0 database version 16)</di=
v><div><br></div><div><b>I have googled,=C2=A0 got the information=C2=A0 th=
at I need to do=C2=A0</b></div><div><br></div><div>1. First shutdown the=C2=
=A0 =C2=A0Postgre Server cluster/instance. ( This is a production server, d=
owntime permissions required if need to do so)=C2=A0</div><div><br></div><d=
iv>2=C2=A0 stop the stanza=C2=A0 and delete the stanza=C2=A0</div><div><br>=
</div><div>3. Then recreate the stanza with the same name from the new=C2=
=A0 Repo Server.</div><div><br></div><div>In need to change the RepoServer =
due to the storage limitations on the RepoServer forced to move to a large =
Repo Server.</div><div>=C2=A0</div><div><div>Can I bypass the step1 ( shutd=
own=C2=A0the postgreserver ?) and do step 2 and step 3,=C2=A0 will this act=
ion stalemate the entire DB server and backup setup.=C2=A0=C2=A0</div><div>=
<br></div></div><div>Request your valuable guidance and advice.</div></div>=
</blockquote><div><br></div><div>repo entries in pgbackrest.conf are number=
ed.=C2=A0 &quot;Just&quot; add repo2-xxxx entries to your existing pgbackre=
st.conf, and then add &quot;--repo=3D2&quot; to your existing pgbackrest co=
mmands.</div><div><br></div><div>(That <i>should</i>=C2=A0work.=C2=A0 I&#39=
;ve never had to try it.)</div><div><br></div></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t b=
oil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></=
div></div></div></div></div>

--000000000000106d6a0640ba13bc--