Home > mailing lists

Thread: Is the logfile the only place to find the finish LSN?

Is the logfile the only place to find the finish LSN?

From

pgchem pgchem

Date:

26 September 2023, 16:00:47

Hello all,

according to:

https://www.postgresql.org/docs/current/logical-replication-conflicts.html

https://www.postgresql.fastware.com/blog/addressing-replication-conflicts-using-alter-subscription-skip

The logfile is the _only_ place to find the transaction finish LSN that must be skipped if logical replication is stuck on a conflict. Is the logfile the only place to find this information, or can it also be found somewhere inside the database, e. g. in some system catalog view?

best regards

Ernst-Georg