Re: cron tasks in pg 9.3

Joe Van Dyk wrote:
> 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.

Yes, you should be able to do that, but there's no scheduling code yet.
There has been talk about porting the execution part (i.e. no UI) of
pgagent into a bgworker, but so far I don't know of any code.

If you want your tasks to just run some queries, that's easy to arrange.
If you want to do things like run separate processes (say pg_dump) it
might be a bit more involved.

The new facilities in 9.4 that let you start dynamic bgworkers would
ease things even more.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services