binary replication montitoring metrics

[jinty]

Hi,

I'm interested in using your exporter to monitor a streaming replication cluster. However it looks like it's missing a few metrics, specifically these would be interesting:

pg_is_in_recovery()
pg_last_xact_replay_timestamp()
pg_last_xlog_replay_location()
pg_last_xlog_receive_location()
pg_current_xlog_location()
pg_is_in_backup()

from http://www.postgresql.org/docs/9.4/static/functions-admin.html

[jinty]

sorry for not attempting a pull request, but, er never done any go programming before and whatever I did would probably need a re-write...

[wrouesnel]

No problem - I am interested in supporting those in metrics. I'll have
to examine our current postgres instance, since I believe our DBAs set
up replication so I should have a good test case.

On 15/12/15 03:59, Brian Sutherland wrote:

sorry for not attempting a pull request, but, er never done any go
programming before and whatever I did would probably need a re-write...

—
Reply to this email directly or view it on GitHub
#1 (comment).

[wrouesnel]

We have pg_stat_replication now, but looking at this list again it's not actually what you were looking for. The new code to handle it extends the model quite well though, so we should be able to support this. Leaving this open after all.