Thanks to everyone for your great answers I have looked into pg_cron, jpgAgent and pgAutomator and enjoyed (j)pgAgent + pgAdmin so far
pg_cron looks great but rewrite my 346 jobs seems painful Adam your tool is really nice and I would be glad to help on this project, btw I am not a developer but I would like to start to code as well Regards Juliano > -------- Original Message -------- > Subject: Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support > pgagent (jobs) > Local Time: 20 October 2017 4:14 AM > UTC Time: 20 October 2017 03:14 > From: adambrusselb...@gmail.com > To: pgsql-general@postgresql.org <pgsql-general@postgresql.org> > > I'm currently in the same boat that I wish there was something better > for running jobs against Postgres than pgAgent. > Using pgAdmin to manage my numerous jobs isn't the best experience > i've ever had to say the least, but it does work. No other tool I > have used will manage pgAgent jobs. > > I worked to alleviate some of my pain with pgAgent, by re-writing the > entire agent portion: https://github.com/GoSimpleLLC/jpgAgent > It uses the same schema as pgAgent, and you can manage it with pgAdmin > just the same, it just has way more features, and has been extremely > stable for me. > > One thing I have wanted to do for a while, is to write an entire > alternative job scheduler / management tool separate from pgAdmin > which will be dedicated to just that single purpose. > I put in a good bit of work on that, but haven't had time to go back > and get it to a point where I can actually release it: > https://github.com/Tostino/pgAutomator > The goal is to have a tool much closer to what is available for SQL > Server, or Oracle compared to what we have today. The backend stuff > is mostly working, I just need to find time to write a frontend to > manage it. > > Anyways, sorry for a bit of rambling. My main point was that this is > something that has been a personal pain point, and I haven't found > anything I liked better up to this point in time. > I'm slowly working on remedying that, but until the time my > alternative is ready, i'm sticking with (j)pgAgent, and pgAdmin to > manage it. > > Thanks, > -Adam > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general