Hello 2012/3/5 Alvaro Herrera <alvhe...@commandprompt.com>: > > 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. >
I agree - it is not simple * workflow support * dependency support a general ACID scheduler can be nice (in pg) but it is not really simple. There was some proposal about using autovacuum demon like scheduler. Pavel > -- > Álvaro Herrera <alvhe...@commandprompt.com> > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
