Hello!
I currently use Slony for replication and want to switch to logical
replication. With Slony I was aware of the replication lag of each slave
in seconds. This info was available regardless if a slave was online or
offline.
For my application I need to know the "delay" of all replicas, wether
they are currently active or not. I.e. a replica may be on the other
side of the world, serving queries there, but has problems to connect to
the master. Even in this case I need to know the replication status of
the replica.
With logical replication, it seems the only available data, eve in case
a replica is offline, is in the pg_replication_slots table, for example:
-[ RECORD 1 ]-------+---------------
slot_name | test_6
plugin | pgoutput
slot_type | logical
datoid | 16402
database | mydns
temporary | f
active | f
active_pid |
xmin |
catalog_xmin | 1116191193
restart_lsn | 2EA/E61E7FA8
confirmed_flush_lsn | 2EA/E626F0B0
So I guess, the replication status of this replica is the
"confirmed_flush_lsn", ie: 2EA/E626F0B0
But how to I get from 2EA/E626F0B0 to a timestamp when this transaction
was added to the WAL files?
I would appreciate any hints, or other methods to get the delay in some
time format.
thanks
Klaus