Re: Streaming Replication patch for CommitFest 2009-09

Kevin Grittner wrote:
> Greg Smith <gsmith@gregsmith.com> wrote:
>> I don't think running that program going to fly for a production
>> quality integrated replication setup though.  The UI admins are
>> going to want would allow querying this easily via a standard
>> database query.  Most monitoring systems can issue psql queries but
>> not necessarily run a remote binary.  I think that parts of
>> pg_controldata needs to get exposed via some number of built-in UDFs
>> instead, and whatever new internal state makes sense too.  I could
>> help out writing those, if someone more familiar with the
>> replication internals can help me nail down a spec on what to watch.
>  
> IMO, it would be best if the status could be sent via NOTIFY.

To where?

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com