Re: Streaming replication status - Mailing list pgsql-hackers

From Robert Treat
Subject Re: Streaming replication status
Date
Msg-id 201001122118.51430.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Streaming replication status  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Tuesday 12 January 2010 17:37:11 Simon Riggs wrote:
> There is not much sense being talked here. I have asked for sufficient
> monitoring to allow us to manage it in production, which is IMHO the
> minimum required to make it shippable. This is a point I have mentioned
> over the course of many months, not a sudden additional thought.
>

Even subscribing to this view point, there is sure to be a significant wiggle 
room in what people find to be "sufficient monitoring". If I had to score the 
monitoring facilities we have for PITR standby, I'd give it about a crap out 
of 5, and yet somehow we seem to manage it. 

> If the majority thinks that being able to find out the current replay
> point of recovery is all we need to manage replication then I will
> happily defer to that view, without changing my opinion that we need
> more. It should be clear that we didn't even have that before I raised
> the point.
>

I'm certainly interested in specifics of what you think need to be exposed for 
monitoring, and I'd be interested in whether those things can be exposed as 
either trace points or possibly as C functions. My guess is that we won't get 
them into core for 8.5, but that we might be able to provide some additional 
facilities after the fact as we get more of these systems deployed.  

-- 
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Streaming replication status
Next
From: "J. Greg Davidson"
Date:
Subject: xml2 still essential for us