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

From: pgchem pgchem <pgchem(at)tuschehund(dot)de>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Is the logfile the only place to find the finish LSN?
Date: 2023-10-04 09:56:51
Message-ID: 436517995.781008.1696413411482@webmail.strato.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all,

on pgsql-general this got no answers, so...

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-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2023-10-04 10:22:13 Re: [HACKERS] make async slave to wait for lsn to be replayed
Previous Message vignesh C 2023-10-04 09:39:44 Re: [PATCH] Add CANONICAL option to xmlserialize