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 1vlWIc-000A87-0C for pgsql-general@arkaria.postgresql.org; Thu, 29 Jan 2026 17:59:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlWIY-000BsI-0A for pgsql-general@arkaria.postgresql.org; Thu, 29 Jan 2026 17:59:18 +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 1vlWIX-000Bs5-22 for pgsql-general@lists.postgresql.org; Thu, 29 Jan 2026 17:59:18 +0000 Received: from mail-oi1-x22b.google.com ([2607:f8b0:4864:20::22b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vlWIM-0000Jm-2W for pgsql-general@lists.postgresql.org; Thu, 29 Jan 2026 17:59:12 +0000 Received: by mail-oi1-x22b.google.com with SMTP id 5614622812f47-45c89d754dfso461131b6e.1 for ; Thu, 29 Jan 2026 09:59:07 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769709545; cv=none; d=google.com; s=arc-20240605; b=dKZtl5pytBtBVlDqCmqWydw3OnYNcV6wlEM3pQNKgAwQIy3oQRV3DeLw1W0V8geH3l Ruyneqh33F6oaf6oflYjv+jmUfkUk5phrTiNJnlJ3PvbVG+L0sU6qcKiQ6jssf27PIoh 7Jf3e+Ezq7PJ5Zuo5VlhojvaMuu791rzQUcZ0KFRSeNSnryUxnvgFpmKsktqMWbZMEou lpKS7B0esRzXFiU7ht/AkcaORRaCWHMyWL5zQ4p9C5f+KkpuJeEQKbcxyevqgIIT9P+4 /wSwJ9lAZ+qgcQg25hXPSNz6bJtRjsh8EktIr5njnKARGpM53YMOtgI083e347cdkEni R6iA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=/Y8KuME5/fcHxZhZ8juIMGUfZr80ike4cCM9f1Ku06A=; fh=4rCG0PM8n0FOokGy8sSWDJpgPdCgp6yIXcpABJ7tUh0=; b=hJXgDX5bvGj0SAdT7geEj5X9mgzQuqU9F0NggKq6PlykEdTWXocDOIt113nca3KpIb pUNMZtjrqeGRwcB/guosij0ojapu7ZPvH7Va/lZJEtnnixFZT4RMjRJBHsffo/LoouDi M2iRWfpINSMu8pDPCTNwQXqs1+kQBtjQwpWg7lCfqMRSW6ZSauUoLPnXg2AtKExWQAWS 30pDxht5Ox3Pc5u0IYpuT/WBq2wSi5i1hEC0Mjqp9io5gFjT3lyxBMpWUZlgnQddxeY9 w/Kf2ohmsh5MoGc46l3JELQv3bi6/jGtiBEGx+JvMmSwYZ7T01TBdPy36+cpky7/Dc8J QB/A==; 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=20230601; t=1769709545; x=1770314345; darn=lists.postgresql.org; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=/Y8KuME5/fcHxZhZ8juIMGUfZr80ike4cCM9f1Ku06A=; b=KQZw7tNbOq7B4oFXN6M8gdW34CkqoECapM1YQEtuAIA7Wo6XAQFLnWZzkNrTw83TZI mzKv+1xL9VQQ1QVKEKVVyUFjDY5VVyy6xhW6vqO46u3LkFpTThPa9ztP5bwOcI8d8TJM UCh791lICbL6kvByDMYFIDyDQrVagaZvPKGo9zX4hX/G7Ipz8MoVjSgu+SgtB74iwYU3 lin5jx0C4Qwpx6zRzvNDko2R16mSsm8kZhv4KoS68Rls2TRvx9ICoACtmrO918eAKIqP ogsf8GHl7M0LUlRKA6WWKB70fNuLOm7IgcQ+sVjYYluWBDdRH6rO1DoanqWlokZPQoFv dADQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769709545; x=1770314345; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=/Y8KuME5/fcHxZhZ8juIMGUfZr80ike4cCM9f1Ku06A=; b=fmjQ7eO19IOByEI2l6gN7Y/LFIYwhdAn5ul+U9MHPggl7itRVzUTiXsboH2FPtPXW5 Q3KWmScyXYrv/ehx/DhWyx4RQfnAqstCoQFdsvTYpJe5wuNCQBVuYZVwTMe58obfxoKp Ak1nkqVkujs3oi2OQ3VOSaw+d3txoVXshkiLUu4SGYTutVLO6bpcTc+9DC6WjwBglAdh 4/0DsaZwZxrQbxpgFUYadESUxbr8Iy7kCzqNlIVq6k86trR9KGHhkUyA2Ml86617wXLa 6SMPT0JlaE5PMuQ/P6yT2S5yaymXhQCi/wzAWJyTdJ4ZHVfbEGov32dUJGJLF0WRYju5 Uq/g== X-Gm-Message-State: AOJu0YzVsZJWjEN7DmnmCDx4vOzjWmLqHiPUJXlisDO7xKoUfvzZ7m9t ZicPPAr14ru/kT4MTuLz/owW26wxlBNFfnYaTc+ZYDrhoZLofU4fW06lIIKgMySbPaJYRnmPjqC p/FUdyimxLNzJnsXaNOpl6qmbnLSXzlc+Cfl3JbU= X-Gm-Gg: AZuq6aKv3hTXsXWEl9Fr5tzNc3igu4Tn0wgk4USz4LCn6psTuKSQbaYNbnJ3x+lA45L y/hc0nP/D+Rvx8WTwHNqHWp+yjZS6i+s+P3T4x4Dg2OkRsjHpFe32uloQsjkSyzAgM5UVW8875Z TPL4RQQajXlfx2G0qwQbZr79qF9M68GXM78C3NdCXRb25hG6KbDuU4QTaOMiItaColeuelQMvfe ZnMn8WzpUJel6n0czJDYNbbt4C32VtxXTrboUSCwrcO3e64iui7nwBuoPOZ4+4USdlV8fDtoj8N IWrVNmP2 X-Received: by 2002:a05:6808:1313:b0:455:daf0:9999 with SMTP id 5614622812f47-45f34d227e5mr180488b6e.50.1769709544903; Thu, 29 Jan 2026 09:59:04 -0800 (PST) MIME-Version: 1.0 References: <1730736265.4259921.1769443263077.ref@mail.yahoo.com> <1730736265.4259921.1769443263077@mail.yahoo.com> <2097370962.4296686.1769449473672@mail.yahoo.com> <5efd76b75e527a6558dd69ba4364699f256a813a.camel@tpg.com.au> <259609552.3013229.1769632103875@mail.yahoo.com> <62048030-5073-4bfc-9565-f8af8084bf6c@dalibo.com> In-Reply-To: <62048030-5073-4bfc-9565-f8af8084bf6c@dalibo.com> From: PetSerAl Date: Thu, 29 Jan 2026 20:58:52 +0300 X-Gm-Features: AZwV_QgrU9spH1a4ll_AkUOOoiuNz14uxp-azWrx3HnZCJISfEJdvNdc84OIge4 Message-ID: Subject: Re: About backups To: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jan 28, 2026 at 8:32=E2=80=AFPM Guillaume Lelarge wrote: > Doesn't matter at all. You'll get a consistent backup. But be aware of not MVCC-safe commands like TRUNCATE. If transaction with such command intersect with beginning of backup, then it may be not consistent. It will see effects of TRUNCATE, but will not see effects of other commands in such transaction.