Re: About backups

[Christophe Pettus]

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