> 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.