Обсуждение: Is the logfile the only place to find the finish LSN?

Поиск
Список
Период
Сортировка

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

От
pgchem pgchem
Дата:
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