Postgres Pro
Downloads
Home   >   mailing lists

Re: pgadmin not processing scheduled jobs - Mailing list pgsql-admin

From Robert Young
Subject Re: pgadmin not processing scheduled jobs
Date
Msg-id c3df65eb0810241400g28d175cfv3bc455fc64868f7b@mail.gmail.com
Whole thread Raw
In response to pgadmin not processing scheduled jobs  ("Robert Young" <robbyoung21@gmail.com>)
Responses Re: pgadmin not processing scheduled jobs
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: "Robert Young"
Date:
Subject: pgadmin not processing scheduled jobs
Next
From: Tom Lane
Date:
Subject: Re: Change in logging behaviour between 8.1 and 8.2