Problems with pgagent Jobs
От | Selber, Heiko |
---|---|
Тема | Problems with pgagent Jobs |
Дата | |
Msg-id | 7280074AC0CE8A4BA00B90CA5BDD1C78FA7506@blns00ea.ww002.siemens.net обсуждение исходный текст |
Список | 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
В списке pgadmin-support по дате отправления: