Postgres Pro
Downloads
Home   >   mailing lists

Is the logfile the only place to find the finish LSN? - Mailing list pgsql-general

From pgchem pgchem
Subject Is the logfile the only place to find the finish LSN?
Date
Msg-id 850790501.593275.1695733247433@webmail.strato.de
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: dld
Date:
Subject: Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })
Next
From: Ron
Date:
Subject: Ad hoc SETOF type definition?