Re: Need some help setting up pgAgent

On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> 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?

No, you have to enable it. On redhat based distros, you'd do something
like "chkconfig <servicename> on". On Debian based distros, I believe
you use the update-rc.d command.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company