Request a Demo
Home   >   mailing lists

Re: About backups - Mailing list pgsql-general

From PetSerAl
Subject Re: About backups
Date
Msg-id CAKygsHTWYHSE+UkNb0dzRXOOsm5tu=BZJ0SH0qAuCvSw2U8GjQ@mail.gmail.com
Whole thread Raw
In response to Re: About backups  (Guillaume Lelarge <guillaume.lelarge@dalibo.com>)
Responses Re: About backups
List pgsql-general
Tree view 
On Thu, Jan 28, 2026 at 8:32 PM Guillaume Lelarge
<guillaume.lelarge@dalibo.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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: UNLOGGED table CREATEd on one connection not immediately visible to another connection
Next
From: Adrian Klaver
Date:
Subject: Re: About backups