Re: Need some help setting up pgAgent

On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> On Mon, Oct 18, 2010 at 2:34 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
>>> Sorry, it looks like it defaulted to the wrong DB.  I created the
>>> schema in the "postgres" database and now I see a Jobs node..
>>
>> :-)
>>
>>> One last question - How do I configure pgAgent to start automatically?
>>
>> You'll need to put together a startup script for your OS, if the
>> debian/ubuntu packager hasn't done so already. I'd suggest copying one
>> from /etc/init.d and tweaking it as required.
>
> This is a bit outside my comfort zone, do you have a startup script
> you can share with me?  I can copy it into /etc/init.d - Thanks!

No I don't (I use a Mac - and never start pgagent automatically
anyway). Can you copy the PostgreSQL script and make appropriate
changes?

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

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