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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Obe, Regina | 2007-12-24 13:43:58 | Re: HOWTO : plpgsql stored function spawn cron job that will run other stored functions |
Previous Message | Milan Cirovic | 2007-12-24 12:09:52 | pgAgent on workstation/client |