Content-Type: multipart/alternative;
 boundary="------------BHnmEdrdYE0vPoa3nRWIF1uw"
Message-ID: <91f9d08c-fb4b-5847-4663-e96994c1f460@gmail.com>
Date: Wed, 9 Feb 2022 19:42:48 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: PG_Base Backup take 8 to 9Hrs
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
In-Reply-To: 
 <KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
Archived-At: 
 <https://www.postgresql.org/message-id/91f9d08c-fb4b-5847-4663-e96994c1f460%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------BHnmEdrdYE0vPoa3nRWIF1uw
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 2/8/22 06:36, Ram Pratap Maurya wrote:
>
> We are using Postgres -11 version and current *PG DB size is 450 GB* .
>
> Archive log enable in Database and we are running Full *PG_Base 
> backup* and it will take 8 to 9 Hrs to complete the backup ,
>
> Please suggest  how to reduce the full DB backup time.
>
Use storage snapshots, faster disks, faster Ethernet adapters and backup 
software that supports deduplication. You are asking the list to 
architect your backup solution. For that, some more information is 
needed: what kind of machine are you using, what OS, how much memory, 
what kind of storage is your cluster running on, what kind of storage 
are you backing it up to, how is the backup storage connected (FC/AL, 
Ethernet, local SATA drives), is there any degree of parallelism and 
things of that nature. In the absence of that information, I can only 
recommend attempting with the --run-faster switch to pg_basebackup. You 
may also try using the Force.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--------------BHnmEdrdYE0vPoa3nRWIF1uw
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 2/8/22 06:36, Ram Pratap Maurya
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com">
      <p class="MsoPlainText"><span style="color:#1F497D">We are using
          Postgres -11 version and current
          <b>PG DB size is 450 GB</b> .<o:p></o:p></span></p>
      <p class="MsoPlainText"><span style="color:#1F497D">Archive log
          enable in Database and we are running Full
          <b>PG_Base backup</b> and it will take 8 to 9 Hrs to complete
          the backup ,<o:p></o:p></span></p>
      <p class="MsoPlainText"><span style="color:#1F497D">Please suggest
           how to reduce the full DB backup time.</span></p>
    </blockquote>
    <p>Use storage snapshots, faster disks, faster Ethernet adapters and
      backup software that supports deduplication. You are asking the
      list to architect your backup solution. For that, some more
      information is needed: what kind of machine are you using, what
      OS, how much memory, what kind of storage is your cluster running
      on, what kind of storage are you backing it up to, how is the
      backup storage connected (FC/AL, Ethernet, local SATA drives), is
      there any degree of parallelism and things of that nature. In the
      absence of that information, I can only recommend attempting with
      the --run-faster switch to pg_basebackup. You may also try using
      the Force.<br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a>
</pre>
  </body>
</html>

--------------BHnmEdrdYE0vPoa3nRWIF1uw--