Re: pgadmin not processing scheduled jobs

From: "Robert Young" <robbyoung21(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgadmin not processing scheduled jobs
Date: 2008-10-24 21:00:00
Message-ID: c3df65eb0810241400g28d175cfv3bc455fc64868f7b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-10-24 23:56:01 Re: Change in logging behaviour between 8.1 and 8.2
Previous Message Robert Young 2008-10-24 20:42:23 pgadmin not processing scheduled jobs