From: | Mike Christensen <mike(at)kitchenpc(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need some help setting up pgAgent |
Date: | 2010-10-18 10:34:45 |
Message-ID: | AANLkTi=kAcgRpadfFPOeCeC9rJWFE4xnvbOpNeP07iXV@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Oct 18, 2010 at 3:07 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
>> Okay I found one that I can use..
>>
>> One question.. Should the connection string in the script have the
>> password for "root" hard coded in it? Or will it use a password from
>> ~/.pgpass automatically? If so, what user account will it find the
>> .pgpass file under? Thanks!
>
> Have the script start pgagent under the postgres account eg;
>
> su - postgres -c 'p/path/to/pgadmin....'
>
> Then it should be able to use postgres' pgpass file. Don't put the
> password in the connection string!
Ok, that worked.. I can at least start and stop it now, and it
remains running when I'm logged off..
So does anything in /etc/init.d get automatically run when the server boots?
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2010-10-18 10:37:48 | Re: Need some help setting up pgAgent |
Previous Message | Dave Page | 2010-10-18 10:07:17 | Re: Need some help setting up pgAgent |