From: | Seb <spluque(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgagent in Debian sid |
Date: | 2009-06-03 20:03:25 |
Message-ID: | 878wk9m6eq.fsf@patagonia.sebmags.homelinux.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Wed, 3 Jun 2009 20:40:26 +0100,
Dave Page <dpage(at)pgadmin(dot)org> wrote:
> On Wed, Jun 3, 2009 at 8:32 PM, Seb <spluque(at)gmail(dot)com> wrote:
>>> It may be easier to drop the schema altogether, grant your user
>>> account access to the postgres database, and then re-create the
>>> pgagent schema using your user account.
>> Yes, this sounds simpler at this point, although I'm not sure what
>> privileges to grant myself to the postgres database? I assume this
>> needs to be done while logged in as the postgres user (i.e. after 'su
>> - postgres; psql postgres'). Thanks.
> Yes, log in as postgres. GRANT CREATE ON DATABASE postgres TO myuser;
> should be enough.
Great, I can see the Jobs node now using my normal user account.
However, right-clicking on the jobs doesn't present an option to create
new jobs; it only shows "_Object list report" and "_Run now" options
under "Refresh" in the context menu. Any further advice appreciated.
Thanks.
--
Seb
From | Date | Subject | |
---|---|---|---|
Next Message | Poonam Nijhawan | 2009-06-04 04:43:55 | pgAgent on Macbook |
Previous Message | Dave Page | 2009-06-03 19:40:26 | Re: pgagent in Debian sid |