Re: Problems with pgagent Jobs

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Selber, Heiko
> Sent: 01 June 2006 10:27
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Problems with pgagent Jobs
>
> Hello,
>
> I have two problems with pgagent jobs:
>
>
> 1. Under certain conditions the 'Jobs' icon doesn't appear in the
> pgadmin window.
>
> I use postgres 8.0.6 on Fedora core 4 with pgadmin 1.4.2 or 1.4.1 on
> FC4, and I installed the postgres DB according to the instructions.
>
> I think that this problem occurs only if a previous version of pgadmin
> is present on the same machine. A freshly installed 1.4 seems to work.
>
> On windows I had to deinstall pgadmin, purge everything
> related I could
> find in the registry/file system, and re-install it.

I can't imagine how 2 versions of pgAdmin could conflict in this way.
More likely I suspect you used a different maintenance DB (template1
instead of postgres for example). The Jobs node will only be shown if
the pgAgent schema and objects are found in the maintenance DB specified
in the connection dialogue.

> 2. When I create a job pgagent doesn't seem to be triggered at all. I
> run it with -l 2 in a console, not as a daemon.
>
> It only writes its periodical debug output to the console, but nothing
> happens:
>
> DEBUG: Clearing inactive connections
> DEBUG: Connection stats: total - 1, free - 0, deleted - 0
> DEBUG: Checking for jobs to run
> DEBUG: Sleeping...
>
>
> I don't think I made an obvious mistake because pgagent works on a
> second machine with roughly the same configuration.

Against the same database or a different one? Also, make sure you didn't
specify a host agent in the job definition unless you know for sure what
should be in there.

> I believe a fresh install of postgresql would help, but I cannot do it
> now.

Almost certainly not required - save yourself the effort :-)

> Where can I look for clues?
>
>
> BTW: Where would the debug output go when pgagent runs as daemon? I
> can't find anything in or near /var/log/messages or
> /var/lib/pgsql/data/pg_log.

Stdout.

Regards, Dave.