> On Jan 28, 2026, at 12:28, felix(dot)quintgz(at)yahoo(dot)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, only transactions that have already committed at the time of the snapshot will appear in the dump.