Thread: pgagent install on windows

pgagent install on windows

From
Howard Cole
Date:
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



Re: pgagent install on windows

From
Dave Page
Date:
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.

Re: pgagent install on windows

From
Howard Cole
Date:
Thanks Dave, you were correct - pgadmin was connecting to template1.