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

Re: pgadmin not processing scheduled jobs

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Robert Young" <robbyoung21(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgadmin not processing scheduled jobs
Date: 2008-10-25 02:43:44
Message-ID: dcc563d10810241943k7e9ee262pb8994409c969e8ca@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Oct 24, 2008 at 3:00 PM, Robert Young <robbyoung21(at)gmail(dot)com> wrote:
> 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?

I'm just guessing, but it could be that your machine is setup to use
local unix sockets and not allow tcp/ip connections.

In response to

pgsql-admin by date

Next:From: Igor NeymanDate: 2008-10-28 17:52:15
Subject: excluding tables from VACUUM ANALYZE
Previous:From: Tom LaneDate: 2008-10-24 23:56:01
Subject: Re: Change in logging behaviour between 8.1 and 8.2

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