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.96) (envelope-from ) id 1wJaR1-0002A8-0x for pgsql-performance@arkaria.postgresql.org; Sun, 03 May 2026 17:16:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wJaR0-0044NF-0E for pgsql-performance@arkaria.postgresql.org; Sun, 03 May 2026 17:16:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wJaQy-0044N6-0W for pgsql-performance@lists.postgresql.org; Sun, 03 May 2026 17:16:49 +0000 Received: from sonic307-21.consmr.mail.sg3.yahoo.com ([106.10.241.38]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wJaQu-000000000fP-30S2 for pgsql-performance@lists.postgresql.org; Sun, 03 May 2026 17:16:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1777828599; bh=xscwACqm+Ank8ov6EaSrHBNgGn8vXog/caxCtcKam6A=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=XoyNjxznNPtjV2tQDVdnNvhPhuV49kkBJ/vFGwB6TgVsFMYEHPYDCGL9cAV/cqzjRa6hQ1vf/XFTWW6H2DutSpzeiszL8wtjM8A1/znLBhzGt0Ledrqjda8z5nm/f3SUY+Dwq+fRM/51XobRLjTL6b3pM3yG1xUPGtXEEfw/GibNiZthO3p3c9NC47Q3/+Fa+LmyXMCHlUft/34CSae6C64kDn5NeEf2L6Aol/OHU9z+r9HUrVeH0f5hKsd+PuhMSL4HI5nWf77tkGiCvNORPf1efO0Xf69sf+rOAA9tdiAEuTqbtJ/qxipRRZLb+8OWKXWMu5dPeTq+iNoXYSeHHA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1777828599; bh=IMceW2EbPcv/5Vc+odQ8KmwIPmifYD908dGya9CVwnw=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Y3DtnSMoRNcIIXubZAj12ph2BGo6foEL1KVsaI1x2Wqn/rGi3NW+6/oGhJ+3hEdez+7npa+m44SWU2JQXtDnTBduiLZVaTNSauJYfVGLtciceO6wvR80BfqXnow5K96/l6bQYJ3faMsZTDJPDUZQmykQuocO6JO4xrhEChwfKHxofKj9GnjHlbQhkTCLT+FAJ9u2F67azYybAHiyOG+qrG8CatwhpGjB6W9FOBkXvBe+RkesRlIicpk5wcajiTrls3EgGQB2bW4oa3d0J4m6sxZJT8a/qSM82UmiwGWZ//TeobT7fuyxsKfPtFODk5046U7hmgxj3cCvYqbgnPcOoA== X-YMail-OSG: zcD02_cVM1n1oxLVa0A8NqruTcWEoGp.leQJNAgfoNasjQDVmewljcjVFhHdI.Z 4fE44nLzYFohvXr_gATFKX5oDMBdUXRkB162dKtAhQlLKfydpAY9zIh0IA6CCT49A89ahfJPLUGT DboJ2bl4zD0ENOf0nvWKhbfesMW3oj0FWA3VeU_YQNZeRLf.t2PyhLOyDqRCsKwo5_G1yNkmNj1Z nLHWiHj4qT8UWRrI8xJLd8pFY2fhIBGGYOdsx834434.vtKSfrbFevjnN6FZv3uhZqhB.MBWMHf0 myIqarvWkTDSKs.XIHycsF5H3PKxmyn79MgbheLEGbFJW5GaXWSLH7MEBYLSdJiKx9qMusKtmC9U R1vsdZMK3FR5ZUnGLNeIZWE9gyhT8hyvZ6dEZ.zdwTpVuwY7wImvFgz24xCJVAat8z3mgm8Z09Lt 9Sw7elkmC8itl5yCZbeYuWu2mhuztTYtn8cZdts8PQRewkvC8OmwbPvnNfnrzJ4NtdkB6I8W3Wcy mtJx20obQoasQK.sGNoPC5N7g3G1VvjJ6SQS.RHxkXocCPVTK32KWvVPdYOWMEEKPgXLwx3e7tK4 dt63sTbMSfGjsa1GWEswC8sgdLvi3YDMWaP9y7Yr3Mi5LoHQhaLTVks0eCZ2vXeOVUA2Qc1DCg6n QUxOUWXM4xOMptxOoT9eyj.RcK68z7_Dmo_cxNs3WxeLwQDFy7cgx7NuAlSTJfMnpXquMWT2gSCa OfY8FpNII.lFSQY.KSTrdcRNNIXfcsmYWMYnrh9V45oBp3nAXaGRd1Ln6SIgO6wDJLc4rwv8zRlY I9oVQZRvsxDs0AJ6kS1ckwxXxnBsTEdcJYq12oxXGMTXw9qYXCO77zOpmgljxAbluq8UYhESRUhh V_lTstnE19Gix0UY2FDttn2kAk4QEOehHY5DsDCJxMO7VhpwhBTUHaGpG.APd6zeT591p7wkYeHn 7c4umZM72oVOx9KHS4_95gTUndL66pnPGRF8v91KX.Ye1sViGbDr1obuRRVIq9ckRXW5Wv2feWvD N6ItFDRGQz3fvbuNMjWGhh5tGlShS8Qy_jJY5Lyhz1bxnRf7V8ggmCD_WBRWn5xe0Ff7QrqEraFy .CwzsrFIDYguJSrVTnJh_V1kwX8eN.49s6q2RlWCU3LaYlWZYcf1UZjpxHzLS9m3QCd5PGVlcgBf 5vbxYNLZfXArHC4oNRBJia.tF6mut.t6ZFldj6k7v9vUExhwHTMO_XZLzeE8cJnC85yhLtbsV09. weMSU81.l.IrtiQ_gGR97Kll02PhaTH7VlTXrLkFDHpPgJSk3eagpHm238OOPZWnUDuaid.Rmj8j P1xjNZiDrR5_8kl1VbQDcQVkVLpTiqHx7_ZEu8bQFSb3xLEZ6VMWaASnR_3mJVL_N341Hc.df1zq 4ym9JGoaGhs6ELQjocKMoTb4arUR0CZg7mBDZXM2uJzpVHP37uGJUqYmKqP5EIyC1G.Jj5IArew5 gEoF2GyrkdikGESiNwqV_IPOJQ7CJuxYQnwJ0GuvMtnsrgBScVhhQTNCpKA5s9pxEoVu7D0d_bKv vpWcVUQBl8m2D6tT_e.ZOi1WmghcuZNZZURCChUFStT0.oz1yD_jSzGaA.mTa.1gHBXnDE8lw6y1 JepKPz0pNCkoBq94El1Rhw3c9EAxUOmoMpzWWbUkxb7vVI1CzBJH1zt.CWOu_9cuwU87XE4s8icq bnO47Hv6Hln12SZSRyvKWPAEtRNub4YOMjudQ4kOp2Fv4ZtvcO4i8pXDg3LQ1GoZiQY9kYG_PLwa SLytWJKEKOYCyuPpGLU7k9Qf9r9Li78HxYbGKlJadlFQEx5j54YsRQRYxkvWO6r3MBpO4M2EA.nD YY3pdV5det6kChcBF.bGnw8I8DtkmqtoJDRDevDBbH3Cbg17MJoINBhrBhvMLl3svsh_hPTWbKIl BH9bGWdiD6t.cj_edaz6bl.NoL8qfhS0brgbZDJCAWK.oOdK_qiNVsay5vuYTygaFjSlC5KX8zNS wSyAaVi3c_nJgeAtvPEKsdDQ8j0DV2ZPO8PMbb9YbNTVkHYyz5Kx5a_uW.YQKF3WJBwQJX0V8Tsz t7Lo.tWUBS38LXFbos9lZrT0f_hrAupD9pg5A.eCxr7ZZLBRzxgJK_r_5ecsxVc6RaunjEOxieJ8 cGiPxM0Di_IytozgkKr3osXdxJOJvgR2y035g7UZ5ZFWK1cDFtokdGeYwVN2y7b0tUhUr2G7P92l PFajMQ8tu2h.JIlELeGkWrDGKFyRMPkR.W917dG.ca9dbXPAyNlnqUn3FQTfRxmMyx38iwP_GV0s wqm5uS0rm1Xw9RE1WMaUnJdSWOaBzdBtkEwQgiiUu_zukTMM8dKygu6xQiU1A X-Sonic-MF: X-Sonic-ID: 23c6d559-7610-4b3e-bbb7-f38bc5d11527 Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.sg3.yahoo.com with HTTP; Sun, 3 May 2026 17:16:39 +0000 Date: Sun, 3 May 2026 17:16:36 +0000 (UTC) From: manish yadav Reply-To: manish yadav To: "pgsql-performance@lists.postgresql.org" , masheed ullah Message-ID: <1960819079.3121752.1777828596848@mail.yahoo.com> In-Reply-To: References: Subject: Re: Postgres DB backup is taking too much time MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Mailer: WebService/1.1.25559 YMailNorrin Content-Length: 762 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk You may try barman with rsync option and adding parallelism i.e. parallel_j= obs =3D6 (based on the CPU core available on the barman machine) Thanks and Regards, Manish Yadav On Sunday 3 May, 2026 at 03:12:45 PM IST, masheed ullah wrote:=20 Hi, We have a database of 20TB, and it's=C2=A0taking almost 24 hours to complet= e. While full restore takes 28 hours. Although we have HA enabled=C2=A0with= primary and multiple replica's. So we need a solution/tool to reduce the RTO, incase of disk failure/ Human= error for data/tables deletion. We are using Barman for backup. My question is "Are there any tools like ZDLRA appliances for Oracle" to re= duce the RTO to less than=C2=A010 hours". Best Regards, Khattak