Re: About backups

From: PetSerAl <petseral(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: About backups
Date: 2026-01-29 17:58:52
Message-ID: CAKygsHTWYHSE+UkNb0dzRXOOsm5tu=BZJ0SH0qAuCvSw2U8GjQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 28, 2026 at 8:32 PM Guillaume Lelarge
<guillaume(dot)lelarge(at)dalibo(dot)com> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2026-01-29 18:37:31 Re: About backups
Previous Message Tom Lane 2026-01-29 15:41:27 Re: UNLOGGED table CREATEd on one connection not immediately visible to another connection