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 1wJTLQ-000Se9-2P for pgsql-performance@arkaria.postgresql.org; Sun, 03 May 2026 09:42:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wJTLP-002nSI-2A for pgsql-performance@arkaria.postgresql.org; Sun, 03 May 2026 09:42:35 +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 1wJTLP-002nS9-1D for pgsql-performance@lists.postgresql.org; Sun, 03 May 2026 09:42:35 +0000 Received: from mail-lj1-x233.google.com ([2a00:1450:4864:20::233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wJTLN-00000000BMV-2342 for pgsql-performance@lists.postgresql.org; Sun, 03 May 2026 09:42:34 +0000 Received: by mail-lj1-x233.google.com with SMTP id 38308e7fff4ca-38e7d983f79so31748721fa.0 for ; Sun, 03 May 2026 02:42:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777801352; cv=none; d=google.com; s=arc-20240605; b=OzN2hPEqVwu9Z24UExPk+CTAGfLOh238L3Q3ZINFNms/TzXrpB4AxIg7y3mJt019JB akDpvEdOEm/CRKiyOPKSewfzwcv4hSzoHexeJECQI2W7Us6J76zTHtu+ko1UKRLBgJ3D BMmq61O3TKYUqvnS1h7z+p+alUKmEgldaSALVRdai5jWKYt3g0FYEfbc/NmC8SOtgKot H4W5iuEahzKcRqiuBHTXlqobBk5z75vUCjf8v3lS2efFkdjRWQ4MuvObCJ8nkISGQWb+ OrmLmEAGwaKG2HEym+rvM5TAQ4FsX3k3HWS5hglPz6PNIiQrIHWW//K/Z7uZON97Td7u XvIQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=c8AuXt4emDn2iIYsx223FyWKyHsXA/r0tNQIymDFzhk=; fh=z/JQ2tSXVGoYKKvtD/yyy3g3xqdpsR82Ngoo7GcsvL4=; b=KWD78x7e8x7no8BS/kqJVdGRe/iNLKL2Y3G0pha7SsNpzfA1nSPyijwjFQ9vUNt0Bn eM9sa1FA7tQFujfQIu+/6AuF+9LaeswFziX+7DPwRVBRC6vzC+i/hwHznSjEeMLNDmM4 CuNqNKqUiR16eW5hn9xocC1uzasFjDmA3BwUjZS2+MKi4pJzgn+dgRZ8XYMn1/wWIaqv 3PUwdO8BXk7yM/UyKWvRiMMXNSZtbkouLnaWfFzqoQ6h9kLmpyfxXJVuWHj7Ad/vSrM/ pEoqWnqByUi2C5t1OUD+WvTHqf8/MAUHfOPrRjs3R7406UzhOGwcS91xXZ7tJ/EH3CJ3 47nA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777801352; x=1778406152; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=c8AuXt4emDn2iIYsx223FyWKyHsXA/r0tNQIymDFzhk=; b=AKs9IWZ2AvSHsWc9rUTjpAYgbe+T47bNBpFkXgTvzs5rSkKYQu+easWBrROCL2xbEG g5o2vau73lsDYh/no4rU/j+5LOY14/BP5j9WQxXpyp6BECmUETfI3kxTv+HkP4pA6Osp ua0twWoWc0/dlQMABqt4viZyPgDIXbZdgaSaPE1usp7ziWzDAMsBlX4KqVBu0oQcm9uI mhY4vhPmKQMuSKI5Jmtf7/S1QGAwp6nBhBuGBYkMd0YZz/joMS7WN/y1PJxCTMqCPJRw gXlVCtWPLEcAy1APm6damt1K60Pft/vKSZoD3Q+Hqq6u4lBP6rajpeJUF1worrctJ+Yt H+uA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777801352; x=1778406152; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=c8AuXt4emDn2iIYsx223FyWKyHsXA/r0tNQIymDFzhk=; b=hDmIK4JrUhDRFm3uPshd0wcIRH/+SZcP2CynRtaPlo7KEsUu6RZY3f4doQ/r2DSgC+ xr21bl/o2CJsR8DuvrRgQxGAs6Q9hgMai2z1A6tIGdVS/6EWazmPq+nyv6i5+ut1ALhs xxMzuB6Od3NLPclkX6Bs0iP/WwDYvpk5myWgafG+kKPOnAigJonW2ZjUvjTHdYHPKS0R 4NoTVXxOsfbTgUZWhYka8wysVsextD4TTa6RetPttoHcycMqroKj4uD7Ylz/amuNBLrj fqN3i2bwjIEjktas0zP+fzDQKSWfe6GrXckWrNG6LbVwXun8R/mcQBlajt7zW31E5LoR AscA== X-Gm-Message-State: AOJu0YzRem4bJ0OuUPWWMtPUX497dx5hd2wTJw4i64YMXk2WGTSwlBM5 uYXhIL4aj5po+FJL98HrdxTWve7JjSBJi+ohz9RCdS3VWY904RPHRMflfE4wFj8YDxqmcrs8/Le zTV89DB3JhXmAQvtFvmxqc7M4ZKDJc4TIkZlDRps3rg== X-Gm-Gg: AeBDieva6WXWy5opcQNgEK1VXa7wqJPvcCis6ziePev2XzS/mlsDr6/kZbGow9pL+KD l8vIekI7EvhRzrxL3tyBnO8IWshwZl8bbz1bMCiy4n8hOa/Ok9DTVdO03isG9VU7k6Cj0aG7Wfg d03PXlWDcE4oWKCj3EULnGVajkJJiHJBazvdlyTKVPLbngglyt0LXNhdcKKUF6HKbCcJLl2g62x ckqH22iNnj8T2uDkYUTLuXmogDpRBh1lif2sBNR2JHLjd5SSrkuq9A58/CC02DRgXSrz6BfgdZr +qRgrI1pcB3nz9G1UT15RKofCGQ/Yr+xwsM9FNp8HuNBXFcujs8OKv9D2etcm7lkBoUe8BZZ8zj YRDwEZuzXm0l5C1ra X-Received: by 2002:a2e:bcc7:0:b0:38c:c36b:8221 with SMTP id 38308e7fff4ca-3937823d9c4mr17064791fa.0.1777801351621; Sun, 03 May 2026 02:42:31 -0700 (PDT) MIME-Version: 1.0 From: masheed ullah Date: Sun, 3 May 2026 12:42:21 +0300 X-Gm-Features: AVHnY4Lo0HummAm7ILZ9qvWMYNKh5Hbpet9Kemjm1XsWWufMCe-ezoM0xpocFaI Message-ID: Subject: Postgres DB backup is taking too much time To: pgsql-performance@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000000b70e10650e6a23a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000b70e10650e6a23a Content-Type: text/plain; charset="UTF-8" Hi, We have a database of 20TB, and it's taking almost 24 hours to complete. While full restore takes 28 hours. Although we have HA enabled with 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 reduce the RTO to less than 10 hours". Best Regards, Khattak --0000000000000b70e10650e6a23a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

We have a database of 20= TB, and it's=C2=A0taking almost 24 hours to complete. While full restor= e takes 28 hours. Although we have HA enabled=C2=A0with primary and multipl= e replica's.
So we need a solution/tool to reduce the RTO,= incase of disk failure/ Human error for data/tables deletion.

W= e are using Barman for backup.
My question is "Are there any tools = like ZDLRA appliances for Oracle" to reduce the RTO to less than=C2=A0= 10 hours".

Best Regards,
Khattak


--0000000000000b70e10650e6a23a--