Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group