Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs) - Mailing list pgsql-general

From Juliano
Subject Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)
Date
Msg-id 4dkaDVG8TS6Z8_F4W39bsE_Hmd7OXUlFXWEFzkbwnS2b4-E3Q4K6oda72luiN-X3QxdEj_DCsbxrUB88Fcr6_IYWgCP0QBZql-EloE0aSSM=@protonmail.com
Whole thread Raw
In response to Re: [GENERAL] Alternative to pgAdmin Postgres Manager that supportpgagent (jobs)  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: [GENERAL] Alternative to pgAdmin Postgres Manager that supportpgagent (jobs)  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-general
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

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
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:
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:

pgsql-general by date:

Previous
From: israel
Date:
Subject: Re: [GENERAL] Weird performance difference
Next
From: Adam Brusselback
Date:
Subject: Re: [GENERAL] Alternative to pgAdmin Postgres Manager that supportpgagent (jobs)