From: | "Selber, Heiko" <heiko(dot)selber(at)siemens(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Problems with pgagent Jobs |
Date: | 2006-06-01 09:27:12 |
Message-ID: | 7280074AC0CE8A4BA00B90CA5BDD1C78FA7506@blns00ea.ww002.siemens.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
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.
I believe a fresh install of postgresql would help, but I cannot do it
now.
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.
Thanks,
Heiko
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Palmer | 2006-06-01 10:34:07 | Visual Studio 2005 support files |
Previous Message | Dave Page | 2006-06-01 07:34:42 | Re: installing admin 81 functions |