Re: Need some help setting up pgAgent - Mailing list pgsql-general

From Mike Christensen
Subject Re: Need some help setting up pgAgent
Date
Msg-id AANLkTi=kAcgRpadfFPOeCeC9rJWFE4xnvbOpNeP07iXV@mail.gmail.com
Whole thread Raw
In response to Re: Need some help setting up pgAgent  (Dave Page <dpage@pgadmin.org>)
List pgsql-general
On Mon, Oct 18, 2010 at 3:07 AM, Dave Page <dpage@pgadmin.org> wrote:
> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen <mike@kitchenpc.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

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Hints for trees
Next
From: Mike Christensen
Date:
Subject: Re: Need some help setting up pgAgent