Applications using postgres frequently require central process serializing specific tasks. We usually implement these with external programs but the reliability of such solution depends on a complexity that require carefull monitoring.
I imagne an extension that would lauch some bg_workers waiting for notify statements like:
NOTIFY <channel> <event>;
and for each <event> catched on the <channel>, calling calling a pl/pgsql function with a single parameter <event>.
A predetermined list of bg_workers would be described in a public table in the postgres database, and red at postgres startup. I wonder how to code a bg_worker waiting for notifications on a channel. Have you any idea on such implementation?
--
