public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: PgBackRest Full backup and N/W reliability
Date: Thu, 29 Aug 2024 14:10:45 -0400
Message-ID: <CANzqJaCZiCET_sd2RDxyMj2TjDTKvYU3Mm9ixymH1fqWRK4__Q@mail.gmail.com> (raw)
In-Reply-To: <CAKgGyB-6_d+ch69jFPd6TaBnHgV5XmpHjP4AfkuRbk8H8EKssA@mail.gmail.com>
References: <CAKgGyB-bipQT+Mtyfv6xntS7w=_tp0sTeMkZLydMgzkC_6yvqg@mail.gmail.com>
<CAKAnmmLzUvQ1oU_UrECZaGeCwUxSbvRq8cKZ9mo+34e3F0f9dA@mail.gmail.com>
<CAKgGyB-6_d+ch69jFPd6TaBnHgV5XmpHjP4AfkuRbk8H8EKssA@mail.gmail.com>
On Thu, Aug 29, 2024 at 12:08 PM KK CHN <[email protected]> wrote:
>
> On Thu, Aug 29, 2024 at 6:54 PM Greg Sabino Mullane <[email protected]>
> wrote:
>
>> On Thu, Aug 29, 2024 at 2:21 AM KK CHN <[email protected]> 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 ?
>
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.
--
Death to America, and butter sauce.
Iraq lobster!
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: PgBackRest Full backup and N/W reliability
In-Reply-To: <CANzqJaCZiCET_sd2RDxyMj2TjDTKvYU3Mm9ixymH1fqWRK4__Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox