I think the docs are kind of confusing.
1) You should install pgagent in the database which is marked as the
maintenance db. This is usually the database called postgres.
2) Then set the service to use that db.
3) Next in PgAdmin III make sure under File->Options->Display you have
pgAgent jobs checked to display.
4) Once you refresh your PgAdmin III or exit and come back in - you
should see a section called Jobs ().. Note this does not appear inside
any specific database - it usually appears after Databases and
Hope that helps,
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Milan Cirovic
Sent: Monday, December 24, 2007 7:10 AM
Subject: [NOVICE] pgAgent on workstation/client
I am using *.bat file for database backup on client/workstation. I run
bat file from the same client machine manually. Contents of file are:
cd C:\"Program Files"\"pgAdmin III"\1.8\
pg_dump -h host -U postgres -f "D:\dbackup\%date%.sql" dbasename
Now, I want to automate process with pgAgent if possible. I have
installed pgAgent from pgAdminIII running sql script as it is stated on
From command line, service is created: C:\"Program Files"\"pgAdmin
III">pgAgent INSTALL pgAgent hostaddr= hos.tad.dre.ss dbname=dbasename
Service is running.
Now, following online installation there should be jobs when I connect
to database in which pgAgent is installed, but there are none. PgAgent
is just in catalogs, no changes in schemas tree.
I did something wrong, or I should create jobs manually?
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
In response to
pgsql-novice by date
|Next:||From: Obe, Regina||Date: 2007-12-24 13:43:58|
|Subject: Re: HOWTO : plpgsql stored function spawn cron job that will run other stored functions|
|Previous:||From: Milan Cirovic||Date: 2007-12-24 12:09:52|
|Subject: pgAgent on workstation/client|