Re: Alternative to pgAdmin Postgres Manager that support pgagent (jobs)

[Juliano <jplinux@xxxxxxxxxxxxxx>]

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: adambrusselback@xxxxxxxxx

To: pgsql-general@xxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxx>

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@xxxxxxxxxxxxxx)

To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-general