On Thu, Jul 18, 2013 at 2:31 PM, Thomas Kellerer <spam_eater@xxxxxxx> wrote:
Joe Van Dyk wrote on 18.07.2013 23:23:What about pgAgent?
Will the custom worker support in 9.3 let me put cron-like tasks into
postgresql?
I have a lot of database functions that should run every few seconds,
every minute, every hour, once a week, etc. Right now, I always have
to have exactly one machine setup with cron tasks that tells
postgresql to run whatever functions are necessary.
It would be super to let postgresql handle all of that.
http://www.pgadmin.org/docs/1.16/pgagent.html
That falls into the category of having to run another singleton (exactly one instance running) bit of software at all times. Not much difference between pgagent and cron, as far as I can tell.
I already always have a single postgresql master running at all times, it would be awesome the postgresql master process could be used to fire off these scheduled tasks. It seems like that would simplify many systems.
Joe
