Re: Suggestion for pgAgent

On Mon, Nov 16, 2009 at 8:07 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> Dear hackers,
>
> 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?

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com