• 0
Sign in to follow this  
Mike Aracic

PostgreSQL replication lag incorrect

Question

1 answer to this question

Recommended Posts

  • 0

Our 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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this