Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)
Great! No worries, after work I will start with some surveys about how to package Postgres extension, and get it onto pgxn. Thanks Juliano Original Message > Subject: Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support > pgagent (jobs) > Local Time: October 21, 2017 9:18 PM > UTC Time: October 21, 2017 8:18 PM > From: adambrusselb...@gmail.com > To: Juliano <jpli...@protonmail.com> > pgsql-general@postgresql.org <pgsql-general@postgresql.org> > > Happy to hear jpgAgent is working alright for you. If you have any > questions with it feel free to ask me. > > If you do want to help with pgAutomator, that sounds like something > you could start to learn on. jpgAgent is pretty much feature complete > as far as my needs go, and no one has requested any additional > features, so i'd rather spend any new time on pgAutomator. > > So one thing I know I need, is to figure out how to package a Postgres > extension, and get it onto pgxn. The database portion of pgAutomator > is pretty complete at this point, so it'd be nice to learn how to > package it up even if I don't end up publishing it until I get a UI in > place. I'll have to look, but i'm sure there are plenty of small > tasks that can be done with the agent itself as well.
Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)
Happy to hear jpgAgent is working alright for you. If you have any questions with it feel free to ask me. If you do want to help with pgAutomator, that sounds like something you could start to learn on. jpgAgent is pretty much feature complete as far as my needs go, and no one has requested any additional features, so i'd rather spend any new time on pgAutomator. So one thing I know I need, is to figure out how to package a Postgres extension, and get it onto pgxn. The database portion of pgAutomator is pretty complete at this point, so it'd be nice to learn how to package it up even if I don't end up publishing it until I get a UI in place. I'll have to look, but i'm sure there are plenty of small tasks that can be done with the agent itself as well. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)
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
Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)
On 10/19/2017 8:14 PM, Adam Brusselback wrote: No other tool I have used will manage pgAgent jobs. they can be managed with SQL, the schema pgAgent uses really isn't that complicated. each job is a row in a table, IIRC. there's also pg_cron, I've never used it, but it is standalone, and managed by SQL statements. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)
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
Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)
On 10/19/2017 3:15 PM, Juliano wrote: Omnidb looks nice, but, I guess doesn't support pgAgent as well, any suggestions? pgAgent isn't part of postgres, its part of pgAdmin. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general