Re: elegant and effective way for running jobs inside a database - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: elegant and effective way for running jobs inside a database
Date
Msg-id 1330977259-sup-581@alvh.no-ip.org
Whole thread Raw
In response to elegant and effective way for running jobs inside a database  (Artur Litwinowicz <admin@ybka.com>)
Responses Re: elegant and effective way for running jobs inside a database  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: elegant and effective way for running jobs inside a database  (Artur Litwinowicz <admin@ybka.com>)
List pgsql-hackers
Excerpts from Artur Litwinowicz's message of lun mar 05 16:18:56 -0300 2012:
> Dear Developers,
>    I am looking for elegant and effective way for running jobs inside a
> database or cluster - for now I can not find that solution.

Yeah, it'd be good to have something.  Many people say it's not
necessary, and probably some hackers would oppose it; but mainly I think
we just haven't agreed (or even discussed) what the design of such a
scheduler would look like.  For example, do we want it to be able to
just connect and run queries and stuff, or do we want something more
elaborate able to start programs such as running pg_dump?  What if the
program crashes -- should it cause the server to restart?  And so on.
It's not a trivial problem.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: foreign key locks, 2nd attempt
Next
From: Pavel Stehule
Date:
Subject: Re: poll: CHECK TRIGGER?