On Mon, Oct 18, 2010 at 2:43 AM, Dave Page <dpage@xxxxxxxxxxx> wrote: > On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen <mike@xxxxxxxxxxxxx> wrote: >> On Mon, Oct 18, 2010 at 2:34 AM, Dave Page <dpage@xxxxxxxxxxx> wrote: >>> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen <mike@xxxxxxxxxxxxx> 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? 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! Mike -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
