Re: About backups - Mailing list pgsql-general

From Christophe Pettus
Subject Re: About backups
Date
Msg-id EC52E7A1-6ADE-4711-990F-8CCA1E34FE0A@thebuild.com
Whole thread Raw
In response to Re: About backups  (felix.quintgz@yahoo.com)
List pgsql-general

> On Jan 28, 2026, at 12:28, felix.quintgz@yahoo.com wrote:
>
> What happens if I start a backup in the middle of a user transaction?
> The transaction can end before or after the backup ends, and it can also start before or after the backup begins.

pg_dump takes a snapshot at the start of the dump, so the dump is consistent at a transaction boundary.  Of course,
onlytransactions that have already committed at the time of the snapshot will appear in the dump. 


pgsql-general by date:

Previous
From: felix.quintgz@yahoo.com
Date:
Subject: Re: About backups
Next
From: Guillaume Lelarge
Date:
Subject: Re: About backups