Re: cron tasks in pg 9.3

On Thu, Jul 18, 2013 at 2:31 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> Joe Van Dyk wrote on 18.07.2013 23:23:
>
> 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.
>>
>
> What about pgAgent?
>
> http://www.pgadmin.org/docs/1.**16/pgagent.html<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