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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1rzWf4-004dzM-Pu
	for pgsql-general@arkaria.postgresql.org; Wed, 24 Apr 2024 07:03:22 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1rzWf3-00CLAz-EH
	for pgsql-general@arkaria.postgresql.org; Wed, 24 Apr 2024 07:03:21 +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 <kumardba27@gmail.com>)
	id 1rzWf3-00CLAr-2x
	for pgsql-general@lists.postgresql.org; Wed, 24 Apr 2024 07:03:21 +0000
Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <kumardba27@gmail.com>)
	id 1rzWex-002f7a-Ni
	for pgsql-general@postgresql.org; Wed, 24 Apr 2024 07:03:20 +0000
Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-518931f8d23so7037380e87.3
        for <pgsql-general@postgresql.org>; Wed, 24 Apr 2024 00:03:15 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1713942194; x=1714546994; darn=postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=z2aB+zR2q+nTpc2xKxkFeU2835FWctjTwJO6qheXtR4=;
        b=bGSWMTq9D4kKUtDTXFqgq7wfg7GskoCdWEXupy/EG1uxl6Cygdj+/MWV8U+llAuJbA
         MZZiG1AWO7UCCsiN7gXhDBTBlFEJuJNIBQTVjjK04GjIKrmhl9snwRLBBt3tTw8PZBfI
         ZyGK8AEiM/DRLeOX6lZPuLSZOGkEz/tg8o0Z9ZFxL+tgafDA0oKQblsHho9KEQ4xmKUG
         WQkGg6J3/exIb5O0lKl043DJVSYYQ4EFaWFcZCxG5laxgcrKt6uRJXVzklG/8Wn3zK9+
         owZx2FoPcKM7zTL/ATOda5raRdYOSDuRQ5mArDW7tumYBDayfOn31V+ZzjQplM5pgDcR
         wqOQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1713942194; x=1714546994;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=z2aB+zR2q+nTpc2xKxkFeU2835FWctjTwJO6qheXtR4=;
        b=AiDX1mggjeQjnS0FoRbShjkCa8B01uBzolKpiyRQWSgN550XInrS9YPJrI0DdqWZMB
         7Xe8P0ig3i0W9DGAD8j6Pcgk1zt+VQ+D2uoYunRytA4hG5kgSmfsAhe4dJHCEAap5Hoq
         N7RCSyv1g06zZL8x42gQnDx7hFt6VxO3P2qaTFQqlP28qKl3sEVG2Due0/9N9St68Kwm
         QAm3TiqloWvqvXCU7RQ+K8kWPApNE4jhpn6PNvCTqqSOurpUzzIG6sNYviHx94Q95tHH
         lOw4iAOqKTYO+CkDXFLG2+3uyw6tQT2M0GH+g+DOFjwK6Zdpm5FO2Ox7l0qyy44LRXSR
         EH0w==
X-Gm-Message-State: AOJu0YxQ+rnegchiiBA4UgqrGTXGiDHEgj2974Fd6hTPZTmWK91BtsD5
	d+UNO8gKln2UbkQ9e1T1M5rS6TDejL8fek7C2VbgdMWuCR7jL+iPA9QngTRhLZHhtetyyvlfdyd
	2kvbs+3z1wP97IbjtVMj1o3zr1SaaP5U6
X-Google-Smtp-Source: AGHT+IFiNFWQjFQ+omKxef9VqpDscPZsRme+KN1jRsZYaGrSoLw5ccyovdVKmWlDMx46ro1OUfRtmKEpoI+0QiaMI94=
X-Received: by 2002:a05:6512:551:b0:51b:812:3c82 with SMTP id
 h17-20020a056512055100b0051b08123c82mr932875lfl.5.1713942194188; Wed, 24 Apr
 2024 00:03:14 -0700 (PDT)
MIME-Version: 1.0
From: jaya kumar <kumardba27@gmail.com>
Date: Wed, 24 Apr 2024 12:33:02 +0530
Message-ID: <CACd4L3u23i3YX6rATRBH1LeaDNnNrWRuuGyW-hVoDeh3F9i7vA@mail.gmail.com>
Subject: Backup_Long Running
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a677450616d243a9"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CACd4L3u23i3YX6rATRBH1LeaDNnNrWRuuGyW-hVoDeh3F9i7vA%40mail.gmail.com>
Precedence: bulk

--000000000000a677450616d243a9
Content-Type: text/plain; charset="UTF-8"

Hi Team,



Production database Backup is running very long hours. Any option to reduce
backup time? Kindly advise me.



DB size: 793 GB



We are taking pg_basebackup backup.



Backup File size=613G



Backup Running Duration: 8 Hours

-- 
Thanks & Regards,
Jayakumar.S
+91-9840864439.

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

<div dir=3D"ltr"><p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;=
font-family:Aptos,sans-serif">Hi Team,</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">=C2=A0</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">Production database Backup is running very long hours. Any opt=
ion
to reduce backup time? Kindly advise me.</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">=C2=A0</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">DB size: 793 GB</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">=C2=A0</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">We are taking pg_basebackup backup.</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">=C2=A0</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">Backup File size=3D613G</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">=C2=A0</p>

<p class=3D"MsoNormal" style=3D"margin:0cm;font-size:11pt;font-family:Aptos=
,sans-serif">Backup Running Duration: 8 Hours</p><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=
=3D"ltr"><div>Thanks &amp; Regards,<br></div>Jayakumar.S<br>+91-9840864439.=
<br></div></div></div></div></div>

--000000000000a677450616d243a9--