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

From: pgchem pgchem <pgchem(at)tuschehund(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Is the logfile the only place to find the finish LSN?
Date: 2023-09-26 13:00:47
Message-ID: 850790501.593275.1695733247433@webmail.strato.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

according to:

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

or

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

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-09-26 17:41:05 Ad hoc SETOF type definition?
Previous Message dld 2023-09-26 12:44:44 Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })