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

Suggestion for pgAgent

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: <pgadmin-hackers(at)postgresql(dot)org>
Subject: Suggestion for pgAgent
Date: 2009-11-16 08:07:36
Message-ID: D960CB61B694CF459DCFB4B0128514C203938037@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgadmin-hackers
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.

Yours,
Laurenz Albe

Responses

pgadmin-hackers by date

Next:From: pgAdmin TracDate: 2009-11-16 18:08:20
Subject: [pgAdmin III] #91: Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0
Previous:From: Guillaume LelargeDate: 2009-11-13 07:32:20
Subject: Re: [GENERAL] CREATE TABLE LIKE and SERIAL

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