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.94.2) (envelope-from ) id 1sjjbv-003Rhg-Ty for pgsql-general@arkaria.postgresql.org; Thu, 29 Aug 2024 18:11:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sjjbs-005W7s-LE for pgsql-general@arkaria.postgresql.org; Thu, 29 Aug 2024 18:11:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjjbs-005W7j-7d for pgsql-general@lists.postgresql.org; Thu, 29 Aug 2024 18:11:04 +0000 Received: from mail-oa1-x35.google.com ([2001:4860:4864:20::35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sjjbl-0027TL-D5 for pgsql-general@postgresql.org; Thu, 29 Aug 2024 18:11:04 +0000 Received: by mail-oa1-x35.google.com with SMTP id 586e51a60fabf-2702f91b6c1so603376fac.0 for ; Thu, 29 Aug 2024 11:10:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724955056; x=1725559856; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=qgQshRTq9uRrpGveegYbfDyQyxVazshBscSofl5vQSM=; b=OQnrlnO+y+HT5WlUvYKaOrk5UBgiuUlF1gxQwfKK7/TD0ybsGGLTb1J3Q24xsj3hQg WCejqpQglZ/C04ngaZtGQnVFEh8gBh9elWj4zwkawVhL4/avmOWNkoERce/m9foDkDQT wJvM7yObTrMTKkb4VQ3OmglqdRFZGZToG1mVYpYcfEY//jKkEwPyPjEhYhUncPsZiaTB k1KEw4eivpOjeuBClJXrSQM6tOQIVooorF1M2O4kwrdXhl7rYFFsxk8J5s10EU2GEWKO PH55aTuxfkogZLiNOs1l+EL7i4vyNhZfqoWXjcY/5A9Qijxij+8x83kaHfFuHaGWupSj 665Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724955056; x=1725559856; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=qgQshRTq9uRrpGveegYbfDyQyxVazshBscSofl5vQSM=; b=E5HNz9fKbIBm6KGjyek3mFE/MrxEEnce2Su7nM3cyus8AgxA57yPZ0hMQsVu1jCvvu AccBTygHLDDGQVBqFmf9Vqp95xAvxVxb7U4OiLPEVNuFTtV2JH2MwOOzSfufDRunG7mI rzyTD8/z5khtQwJ6Vg617CBeUykDySHfXxNvRu8ZsDDOAATb4iwku2ulHq9A1hajNGdc QG3Q8WesKTqWadXvwI9oSleyrFwqH630IFYQDV2i3HqGHrTQAdYwv02LnX8c/0sgzT+n M0GTogcy18GDxMhiusKwwOpzkUG4+SQbk2mZbAs/nPPt1tj/7LS286qFEg6dsZIcyMgI ORTQ== X-Gm-Message-State: AOJu0YwSnwELyBiGLn89s/Xaj9UDHIVY5dl+Diw8QJpb2yra0PXSsX0G IDrhxKnR+UGxpGW6dhaOtU64B6Mm0nFrSgbzI8OASn9EKDP+iF6o8lJlMnc/4pqZBUoKepcWx4J v9PE2Dp8DVJ+SeYUbjJ8gPmlWU3a0WQ== X-Google-Smtp-Source: AGHT+IFYe7uO8Hww/kdi5gSeuOEvhZZpB1tFy8QABUIR69E8w1n9C2n3klYlfd3ay/JNqnMAWm9d8R+5NgzlBdaU248= X-Received: by 2002:a05:6870:2105:b0:258:3455:4b2f with SMTP id 586e51a60fabf-2779b787ecdmr1489704fac.17.1724955056055; Thu, 29 Aug 2024 11:10:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Thu, 29 Aug 2024 14:10:45 -0400 Message-ID: Subject: Re: PgBackRest Full backup and N/W reliability To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000005eab080620d66590" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005eab080620d66590 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Aug 29, 2024 at 12:08=E2=80=AFPM KK CHN wrote: > > On Thu, Aug 29, 2024 at 6:54=E2=80=AFPM Greg Sabino Mullane > wrote: > >> On Thu, Aug 29, 2024 at 2:21=E2=80=AFAM KK CHN wrot= e: >> >>> 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 ? > We can't answer that. It depends on what else your PG and PgBackRest servers are doing when "pgbackrest backup" runs. > 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 ? > "pgbackrest backup" reads the config file when it starts. > Is there a limit for proces max. setting ? > I think you need managed DBA services. --=20 Death to America, and butter sauce. Iraq lobster! --0000000000005eab080620d66590 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Aug 29, 2024 at 12:08=E2=80=AFPM = KK CHN <kkchn.in@gmail.com>= wrote:

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=C2=A0 using PgBackRest f= rom a production server=C2=A0to Reposerver.=C2=A0=C2=A0
...=C2=A0
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
<= div>
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 ba= ckup time.


what will be the ideal process-max number to use ?=C2=A0
=

We can't answer that.=C2=A0 It depends= on what else your PG and PgBackRest servers are doing when "pgbackres= t backup" runs.
=C2=A0
Once I u= pdate the process-max param in pgbackrest.conf ,=C2=A0 do I need to stop an= d=C2=A0 start the pgback rest ?=C2=A0

Or just editing the pgbackre= st.conf on the fly will reflect the increased process-max=C2=A0 numbers adv= antage ?=C2=A0 =C2=A0

"pgbackrest backup" reads the config file when it starts.<= div>=C2=A0
Is there a limit for pr= oces max. setting ?

I= think you need managed DBA services.

--
Death to America, and butter sauce.
Iraq lob= ster!
--0000000000005eab080620d66590--