Re: scheduler in core - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: scheduler in core
Date
Msg-id 4B82CA5B.3060300@enterprisedb.com
Whole thread Raw
In response to Re: scheduler in core  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: scheduler in core
List pgsql-hackers
Jaime Casanova wrote:
> On Sun, Feb 21, 2010 at 1:11 PM, Simon Riggs <simon@2ndquadrant.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.

> 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


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Reason why set-value functions not allowed in GREATEST(), etc?
Next
From: Pavel Stehule
Date:
Subject: Re: scheduler in core