Re: Streaming replication status

Fujii Masao wrote:
> On Mon, Jan 11, 2010 at 5:36 PM, Craig Ringer
> <craig@postnewspapers.com.au> wrote:
>   
>> Personally, I'd be uncomfortable enabling something like that without _both_
>> an admin alert _and_ the ability to refresh the slave's base backup without
>> admin intervention.
>>     
>
> What feature do you specifically need as an alert? Just writing
> the warning into the logfile is enough? Or need to notify by
> using SNMP trap message? Though I'm not sure if this is a role
> of Postgres.
>   

It's impossible for the database to have any idea whatsoever how people 
are going to want to be alerted.  Provide functions to monitor things 
like replication lag, like the number of segments queued up to feed to 
archive_command, and let people build their own alerting mechanism for 
now.  They're going to do that anyway, so why waste precious time here 
building someone that's unlikely to fit any but a very narrow use case?

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com