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

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

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

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

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

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: adambrusselback@gmail.com

To: Juliano <jplinux@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.