Monitor streaming replication about libzbxpgsql HOT 10 OPEN

I've implemented a decent method of monitoring streaming on 9.2+, but it requires the config file mods from libzbxpgsql 1.1.

I'll put together a sample in the next few days and share it here.

--Rob

from libzbxpgsql.

Hello! Just interesting what is the status of this issue?

from libzbxpgsql.

Work hasn't started on this feature yet though I have done some research into how it should be measured. Scheduling is uncertain I'm afraid.

Code contributions are welcomed.

from libzbxpgsql.

Unfortunately I'm not a C programmer, but isn't it hard to add one key with one query "SELECT pg_is_in_recovery()"?
Also useful to know replication time lag in seconds:
SELECT extract(epoch from now() - pg_last_xact_replay_timestamp())

from libzbxpgsql.

That should be fairly simple, yes. If it would be valuable I can look to add it soon. Testing my memory, but I was looking at ways to query the transaction log position on all cluster members to determine their progress.

In the mean time, you can use the Query item keys to execute customer queries according to your needs.

from libzbxpgsql.

Thanks! Kindly in PostgreSQL I prefer to not use word "cluster" because it is just master-slave replication.

from libzbxpgsql.

I've heard it said before from other PostgreSQL users that clustering is not the right term. So I'll gladly reconsider. I grew up on Windows Failover Cluster Services which only supports active-passive but still counts itself as a cluster... I guess today it means something more impressive.

from libzbxpgsql.

OK - I've put something in Github for you guys to try out. Let me know if it works for you.
libzbxpgsql-streaming

from libzbxpgsql.

Any news on testing/implementing @robbrucks suggestion?

from libzbxpgsql.

It's a great suggestion and I'd love to implement it, but unfortunately my develop efforts are heavily steered by whatever projects I have going on at work. In the meantime, I'd gladly work with anyone on a pull request or recommend that you check out Rob's template: https://github.com/robbrucks/libzbxpgsql-streaming

from libzbxpgsql.