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 1rzeH2-005b91-SJ
	for pgsql-general@arkaria.postgresql.org; Wed, 24 Apr 2024 15:11:05 +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 1rzeH0-00FmSs-Ot
	for pgsql-general@arkaria.postgresql.org; Wed, 24 Apr 2024 15:11:02 +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 <adrian.klaver@aklaver.com>)
	id 1rzeGz-00FmSk-Pb
	for pgsql-general@lists.postgresql.org; Wed, 24 Apr 2024 15:11:02 +0000
Received: from wfhigh5-smtp.messagingengine.com ([64.147.123.156])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1rzeGw-002j0J-E3
	for pgsql-general@postgresql.org; Wed, 24 Apr 2024 15:11:01 +0000
Received: from compute3.internal (compute3.nyi.internal [10.202.2.43])
	by mailfhigh.west.internal (Postfix) with ESMTP id 1BBC1180018E;
	Wed, 24 Apr 2024 11:10:55 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute3.internal (MEProxy); Wed, 24 Apr 2024 11:10:55 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm2; t=1713971454;
	 x=1714057854; bh=Fph++VMWSRnXZfek+V8MiOta/+WlIhzVw6nKJYJzKgc=; b=
	X23IPcRBZjxCrHBjk4bJC5YGnyMAwzoliFIpyBlEK42GW6HZc8Yu6HHYIVuEpMIj
	ZhRB8JMC+BUFsSh+Fa8P9OyFIwK9z7Gdx5++gkEsVc5GTttjNOrlP98rrIiHjtiq
	cazphH5blzKYFu+s+8psghPhynQsHx1ioQdC9ycFi0AhxVgCseL42rJok6H8yI26
	wcfuvW2DFRDwotMzsQh08/jczMeoX5sJoBSk2jM8i3F+8yJOrOIscuZdj5whz7yp
	zdXSshpCoR9lIN18Ejc5Nx4WZ7fyum74LPutP5W0s4UXxyvg61nGXHj5Y8Lv8RaW
	W5N7KFEU5/uqM2SS3HDOiA==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1713971454; x=
	1714057854; bh=Fph++VMWSRnXZfek+V8MiOta/+WlIhzVw6nKJYJzKgc=; b=Q
	UwNg3+YcFvaXRc4lSs8p9jEmytGHNerubGsxx/pgycR2znQ7+NK0GwTqhdUoxuhm
	1ENDUU4TeypgQPbI1snzkmq56L2vKB0KZAjxsVdSJLSmOEuDtt9W04QLhdB8PjZl
	dK4Vx22IKW/bDKPYVYBkxWrPYvw8C5dWSAlj/JXbGAWx4XOXMatqGNc/AzQMtx1D
	JcMlTIfo3uOhfZzHT5kaN+CDx8HeSmJ7Hy4i217lc0Zbp/cJ5FjR2kmzN5zJWxXD
	pmwbvu46oaTgyebBZIbm1U2hCfzUEOh8U0pzmndBZGiURsXzVXDFvyxOs+hJAJp+
	OBTbrG9NWkoY/cI2MtJhg==
X-ME-Sender: <xms:_iApZv-7sYwH6THnbCXORkGa4Uw1929cOdGY6k1Qpa0eZUG5UGTiDg>
    <xme:_iApZrtBnk8y-C8J5KBSN03vGxr22522Bs28rp91Qiy2dOnfuCJG0BDJrtcw4Z9WA
    j87aZIiy6JzfgQ>
X-ME-Received: <xmr:_iApZtBWNM91NsvfbdoEUQXqVNPsdY3gzbsU9uGgnTskrDDb-hb86CnObF-5b7oQq_TChG-nIqKKMJ5_OEOVBpIeftqw_Q>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrudelhedgvdehucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne
    cujfgurhepkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhi
    rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh
    hmqeenucggtffrrghtthgvrhhnpeeivdfhieehheegueeileejieettdejhedugeefleek
    vdelkeehtdfgiefffeekudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh
    grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm
X-ME-Proxy: <xmx:_iApZrdC6-s0uTzWVbmBqtOPhgQSxAS4_WdPH544Dnpf9iR9OmdvEg>
    <xmx:_iApZkOWE0CRJc74LTNxY-vKaj4MmxIrhq8EDjoKz1JxUs9kyEl7Kg>
    <xmx:_iApZtnIAQLxIvE0stV-TSms-LxaceL_L0Kyl-u-KQq4zBtxqmToVA>
    <xmx:_iApZusL3z1iwlot1TG7q96m-IFiZnj8E1A4MDglTXk6pce7FYUZLQ>
    <xmx:_iApZtYIVH5OMVvwCHMpEonE_xW-1Q0FVUbyCzC1mS3rKzwLsxK7puYB>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed,
 24 Apr 2024 11:10:53 -0400 (EDT)
Message-ID: <6862f40d-22e5-4cc8-92d3-64f940b933af@aklaver.com>
Date: Wed, 24 Apr 2024 08:10:52 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Backup_Long Running
To: jaya kumar <kumardba27@gmail.com>, pgsql-general@postgresql.org
References: <CACd4L3u23i3YX6rATRBH1LeaDNnNrWRuuGyW-hVoDeh3F9i7vA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CACd4L3u23i3YX6rATRBH1LeaDNnNrWRuuGyW-hVoDeh3F9i7vA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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/6862f40d-22e5-4cc8-92d3-64f940b933af%40aklaver.com>
Precedence: bulk

On 4/24/24 00:03, jaya kumar wrote:
> Hi Team,
> 
> Production database Backup is running very long hours. Any option to 
> reduce backup time? Kindly advise me.

Hardware specifications?

Network specifications?

The actual pg_basebackup command used?

Server(s) user load?

> 
> 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.

-- 
Adrian Klaver
adrian.klaver@aklaver.com