im using logical replication in postgres but SELECT
slot_name,
confirmed_flush_lsn,
pg_current_wal_lsn(),
(pg_current_wal_lsn() - confirmed_flush_lsn) AS lsn_distance
FROM pg_replication_slots;
lsn_distance is keep on increasing why is that ?
a
Augustin Lafanechere (Airbyte)
06/03/2022, 10:57 AM
Hey @Dharshan Viswanathan, please post on our forum if you need troubleshooting assistance 🙏🏻