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