Re: scheduler in core

2010/2/22 Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>:
> Jaime Casanova wrote:
>> On Sun, Feb 21, 2010 at 1:11 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>> There is currently no way to run a separate daemon process that runs
>>> user code as part of Postgres, so that the startup code gets run
>>> immediately we startup, re-run if we crash and shut down cleanly when
>>> the server does. If there were some way to run arbitrary code in a
>>> daemon using an extensibility API then we wouldn't ever get any requests
>>> for the scheduler, cos you could write it yourself without troubling
>>> anybody here.
>>
>> ah! that could get rid of one of my complaints, and then i could just
>> work the rest in pgAgent...
>
> Yeah, seems like a good idea. Slon daemon and similar daemons could also
> use it.
>

I like it. I thought about some workflow system integrated with scheduler.

Regards
Pavel

>> so, is this idea (having some user processes be "tied" to postmaster
>> start/stop) going to somewhere?
>
> I've added this to the TODO list. Now we just need someone to write it.
>
> --
>  Heikki Linnakangas
>  EnterpriseDB   http://www.enterprisedb.com
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>