Locked
Discussion interactions are currently paused.
PostgreSQL replication lag incorrect
Why is my PostgreSQL replication lag consistently off by some large number of seconds?
Mike_Aracic
Posted 14 years ago·Last reply 14 years ago
1 comment
Locked
Discussion interactions are currently paused.
Why is my PostgreSQL replication lag consistently off by some large number of seconds?
Mike_Aracic
OP14 years agoOur PostgreSQL replication datasource, with implementation described here includes some scripts used to extend snmpd. One of them uses date commands with a -u option. This assumes that your databases use UTC. If they do not report the time in UTC, this will cause a consistent error. Depending on the specifics, you may want to remove the -u, or possibly apply an offset in seconds to correct for the discrepancy.