From: Robert Young <robbyoung21@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pgadmin not processing scheduled jobs
Date: Fri, 24 Oct 2008 15:00:00 -0600
Message-ID: <c3df65eb0810241400g28d175cfv3bc455fc64868f7b@mail.gmail.com> (raw)
In-Reply-To: <c3df65eb0810241342u5f91731aubfaf839fd8416b2b@mail.gmail.com>
References: <c3df65eb0810241342u5f91731aubfaf839fd8416b2b@mail.gmail.com>
I've solved the issue. pgagent.pga_job.jobhostagent must be blank. Thanks
to this link http://forums.enterprisedb.com/posts/list/1419.page
Anyway, the docs say ... "optionally the hostname of a specific machine
running pgAgent, if this job should only run on that specific server. If
left empty, any server may run the job. This is not normally an issue for
SQL-only jobs, however any jobs with batch/shell steps may need to be
targetted to a specific server." ..., so why didn't it work when I specified
the host of 127.0.0.1 or localhost?
Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: robbyoung21@gmail.com
Subject: Re: pgadmin not processing scheduled jobs
In-Reply-To: <c3df65eb0810241400g28d175cfv3bc455fc64868f7b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox