> 1 июля 2022 г., в 12:41, Nikhil Shetty <nikhil.dba04@gmail.com> написал(а):
>
> I think this tx can be safely removed
> How can I remove this? I can test whether this is the problem
I'v thought more about it and don't see any sense in removing tx from WAL-G code.
The very same virtual transaction would be started implicitly by "select pg_stop_backup()" SQL call. It will obtain a
snapshotholding global xmin.
I don't think we can make anything here on WAL-G side, this is how Postgres backup API works.
But I'd recommend focusing on eliminating lag of the WAL archivation. Why did you have so many unarchived WALs? Maybe
itworth some monitoring etc.
Thanks!
Best regards, Andrey Borodin.