MIME-Version: 1.0
References: <CAKgGyB-bipQT+Mtyfv6xntS7w=_tp0sTeMkZLydMgzkC_6yvqg@mail.gmail.com>
 <CAKAnmmLzUvQ1oU_UrECZaGeCwUxSbvRq8cKZ9mo+34e3F0f9dA@mail.gmail.com>
In-Reply-To: <CAKAnmmLzUvQ1oU_UrECZaGeCwUxSbvRq8cKZ9mo+34e3F0f9dA@mail.gmail.com>
From: KK CHN <kkchn.in@gmail.com>
Date: Thu, 29 Aug 2024 21:37:39 +0530
Message-ID: <CAKgGyB-6_d+ch69jFPd6TaBnHgV5XmpHjP4AfkuRbk8H8EKssA@mail.gmail.com>
Subject: Re: PgBackRest Full backup and N/W reliability
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003197300620d4ad65"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB-6_d%2Bch69jFPd6TaBnHgV5XmpHjP4AfkuRbk8H8EKssA%40mail.gmail.com>
Precedence: bulk

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

On Thu, Aug 29, 2024 at 6:54=E2=80=AFPM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> On Thu, Aug 29, 2024 at 2:21=E2=80=AFAM KK CHN <kkchn.in@gmail.com> wrote=
:
>
>> I am doing a full backup  using PgBackRest from a production server to
>> Reposerver.
>>
> ...
>
>> If so, does the backup process start  again from  scratch ?   or it
>> resumes from  where the backup process is stopped   ?
>>
>
> It resumes. You will see a message like this:
>
> WARN: resumable backup 20240829-091727F of same type exists -- invalid
> files will be removed then the backup will resume
>
> Any suggestions much appreciated
>>
>
> Boost your process-max as high as you are able to speed up your backup
> time.
>
>
what will be the ideal process-max number to use ?

 Once I update the process-max param in pgbackrest.conf ,  do I need to
stop and  start the pgback rest ?

Or just editing the pgbackrest.conf  on the fly will reflect the increased
process-max  numbers advantage ?

Is there a limit for proces max. setting ?

> Cheers,
> Greg
>
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Thu, Aug 29, 2024 at 6:54=E2=80=AF=
PM Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@g=
mail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-le=
ft:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Thu, Aug 29, 2024 at 2:21=E2=
=80=AFAM KK CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com" target=3D"_blank"=
>kkchn.in@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blo=
ckquote class=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"><div>I am do=
ing a full backup=C2=A0 using PgBackRest from a production server=C2=A0to R=
eposerver.=C2=A0=C2=A0</div><div></div></div></blockquote><div>...=C2=A0</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 dir=3D"ltr"><div>=
If so, does the backup process start=C2=A0 again from=C2=A0 scratch ?=C2=A0=
 =C2=A0or it resumes from=C2=A0 where the backup process is stopped=C2=A0 =
=C2=A0?=C2=A0<br></div></div></blockquote><div><br></div><div>It resumes. Y=
ou will see a message like this:</div><div><br></div><div>WARN: resumable b=
ackup 20240829-091727F of same type exists -- invalid files will be removed=
 then the backup will resume<br></div><div><br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Any suggestions much appr=
eciated</div></div></blockquote><div><br></div><div>Boost your process-max =
as high as you are able to speed up your backup time.</div><div><br></div><=
/div></div></blockquote><div><br></div><div>what will be the ideal process-=
max number to use ?=C2=A0</div><div><br></div><div>=C2=A0Once I update the =
process-max param in pgbackrest.conf ,=C2=A0 do I need to stop and=C2=A0 st=
art the pgback rest ?=C2=A0</div><div><br></div><div>Or just editing the pg=
backrest.conf=C2=A0 on the fly will reflect the increased process-max=C2=A0=
 numbers advantage ?=C2=A0 =C2=A0</div><div><br></div><div>Is there a limit=
 for proces max. setting ?</div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><div></div><div>Cheers,<=
/div><div>Greg</div><div><br></div><div>=C2=A0</div></div></div>
</blockquote></div></div>

--0000000000003197300620d4ad65--