pgagent install on windows

Started by Howard Coleabout 19 years ago3 messagesgeneral
Jump to latest
#1Howard Cole
howardnews@selestial.com

Hi,

I have a few of problems installing the pgagent on windows, running
version 8.2

1. When I run the pgagent script on the postgres database, it seems to
run and commit successfully, but when I view the schemas for the
postgres database, there is no new schema for the pgagent. (is it hidden?)

2. The new jobs node does not appear in pgadmin

I have tried this on 8.2.1 and 8.2.3. I am getting regular output the
application log with log level 2 so the agent appears to be running -
its just that I cannot create any jobs?

Howard Cole
www.selestial.com

#2Dave Page
dpage@pgadmin.org
In reply to: Howard Cole (#1)
Re: pgagent install on windows

Howard Cole wrote:

Hi,

I have a few of problems installing the pgagent on windows, running
version 8.2

1. When I run the pgagent script on the postgres database, it seems to
run and commit successfully, but when I view the schemas for the
postgres database, there is no new schema for the pgagent. (is it hidden?)

It is by pgAdmin.

2. The new jobs node does not appear in pgadmin

I have tried this on 8.2.1 and 8.2.3. I am getting regular output the
application log with log level 2 so the agent appears to be running -
its just that I cannot create any jobs?

pgAdmin will look for the pgAgent objects in the "Maintenance Database".
Check in your server properties that you are using postgres and not
template1 or some other database.

Regards, Dave.

#3Howard Cole
howardnews@selestial.com
In reply to: Dave Page (#2)
Re: pgagent install on windows

Thanks Dave, you were correct - pgadmin was connecting to template1.