On Sun, Oct 3, 2010 at 07:07, Karl Denninger <k...@denninger.net> wrote: > Now how do I get an arithmetic difference between the two? There will > (usually) be a small difference between the master and slave on a busy > system - what I want to do is query both and if the difference in their > locations is greater than some defined size, start raising hell (e.g. > sending SMS to people, etc)
Take a look at this code for an example: http://munin-monitoring.org/browser/trunk/plugins/node.d/postgres_streaming_.in?rev=3905 I *think* it's complete :-) > With Slony there was a set of system tables that would tell me how many > unapplied changes were in the queue. From this I could determine health - > if the number was more than some reasonably-small amount, something was > broken and alarms were to be raised. Yeah, streaming can't do it quite so conveniently for you, since the view can only talk to one database at a time. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
