Monitoring Streaming Slave Lag Effectively

(Keith Fiske) One of the easiest ways to monitor slave lag when using streaming replication is to turn hot standby on your slave and use pg_last_xact_replay_timestamp() and/or the other recovery information functions. Here’s an example query to run on the slave systems to get the number of seconds b

Read More - Register for Free Membership