Skip site navigation (1) Skip section navigation (2)

Re: pgAgent on workstation/client

From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
To: "Milan Cirovic" <mine(dot)bones(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: pgAgent on workstation/client
Date: 2007-12-24 12:56:36
Message-ID: 53F9CF533E1AA14EA1F8C5C08ABC08D202F434FB@ZDND.DND.boston.cob (view raw or flat)
Thread:
Lists: pgsql-novice
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
Tablespaces.
 
Hope that helps,
Regina
 
 

________________________________

From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Milan Cirovic
Sent: Monday, December 24, 2007 7:10 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] pgAgent on workstation/client


Hi,

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
http://www.pgadmin.org/docs/1.4/pgagent-install.html.

From command line, service is created: C:\"Program Files"\"pgAdmin
III">pgAgent INSTALL pgAgent hostaddr= hos.tad.dre.ss dbname=dbasename
user=postgres

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?

Regards



-----------------------------------------
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, ReginaDate: 2007-12-24 13:43:58
Subject: Re: HOWTO : plpgsql stored function spawn cron job that will run other stored functions
Previous:From: Milan CirovicDate: 2007-12-24 12:09:52
Subject: pgAgent on workstation/client

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group