Skip site navigation (1) Skip section navigation (2)

Re: Suggestion for pgAgent

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Dave Page *EXTERN*" <dpage(at)pgadmin(dot)org>
Cc: <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Suggestion for pgAgent
Date: 2009-11-17 07:50:06
Message-ID: D960CB61B694CF459DCFB4B0128514C20393803E@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgadmin-hackers
Dave Page wrote:
> > I asked this question on pgadmin-general before, and
> > there was no reply. Maybe this list is more appropriate.
> >
> > When you configure an SQL job step, you can configure a database
> > on which the script should run, but you cannot specify a database user.
> >
> > I'd like to define schedules for various database users, and
> > while it would be possible to work around the limitation by
> > writing some wrapper functions in the database, the best thing
> > from my perspective would be to enhance pgAgent (and pgAdmin III)
> > to support a database user that pgAgent uses to connect to
> > execute a certain job step.
> >
> > Is that an option? I think it would be a valuable addition,
> > and it would alleviate one of the "security concerns" stated
> > in the documentation.
> 
> Sure, it's definitely an option - provided it can be done in a secure
> way. Want to work on it?

I should be able to change pgAgent accordingly, but I am not an
accomplished GUI programmer and have no experience with wxWidgets,
so I don't want to promise that I can do the necessary modifications
in pgAdmin.

Can you think of any security concerns?

Yours,
Laurenz Albe

In response to

Responses

pgadmin-hackers by date

Next:From: Ashesh VashiDate: 2009-11-17 12:35:05
Subject: Re: PATCH(WIP): Printing Support And Save GQB/Explain as an image
Previous:From: Dave PageDate: 2009-11-17 04:38:10
Subject: Re: Suggestion for pgAgent

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group