From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
To: "Vishal Arora" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
Date: Mon, 16 Jul 2007 17:21:58 +0530
Dear Vishal/Ashish,
Sorry to say that... Kindly give me the steps in widows format please...
I done as per your steps only..
1. step i done it .. Its ran fine..
2. step also i done it. ( I replace the path of pgAgent from C:\Program
Files\Postgresql to D:\Program Files),
What is your Connection String you have given to install PgAgent Service.?
3. Login using Postgres user account in windows.:- it is working fine.
4. Try to access pgAdmin III tool in that login. :- This is also working
fine ..I can connect with pgAdmin III
5. Login back to your normal account. :- Yes i login back in my normal
account and password
6. Start pgAgent service using the following command on command prompt
* Net start pgAgent :- Yes here only i face a problem the error is
(C:\Program Files\PostgreSQL\8.2\bin> Net start pgAgent
the error is "The Service did not start due to
a logon failure."
7. Create a new job using PgAdmin III :- Yes i created One new job here.
8. Under step tab click Add to add new step.
* Specify some name:- Yes here i given BACKUP
* Kind - SQL / Batch depending upon the kind of job to be performed.
: - Yes here i selected SQL only.
* Database on which the job is to be performed. :- Yes i selected
database name.
* Definition tab would contain a SQL command if kind selected is SQL:
Yes here i given pg_dump <database name> to D:\AGBACKUP\AG.SQL
pg_dump is not a sql command so you have to create a batch file to execute
this command. Kind is to selected as Batch and in definition tab give the
path to that batch file.
* Definition tab would contain path of Batch file if kind selected is
Batch
9) Under Schedule tab in Job window click Add to add new schedule for
the
job
* Specify some name : Yes here i given BCKP1
* Specify the start date & time:- Yes i given start date and time
* Specify the end date and time :- Yes i given end date and time
* Specify days or weekdays, months when the task needs to be
performed in
days tab :- Yes i given monday,wednesday,Friday
* Specify time hours & Minutes when you want the task to be
performed.
(Atleast One hour & minute to be selected.) :- Yes i given One hour and
30mnts
If you have selected One Hour that means 1 'O' clock in night that is 01:30
HRS in night it would perform the task.
Suggestion - to test remove check from hours and put some more in minutes so
that every hour after some minutes the task is performed.
* Specify exception if any when you do not want the task to be
performed. :- No i didn't give any thing..
Kindly guide me ....
Thanks & Regards
Jayakumar M
________________________________
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Mon 7/16/2007 12:38 PM
To: Jayakumar_Mukundaraju; [EMAIL PROTECTED];
pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
Hi Jayakumar,
PgAgent for windows
1) Run PgAgent.sql script in maintenance database (Postgres database
by
default).
2) Install PgAgent service using the following command on command
prompt -
* "C:\Program Files\PostgreSQL\8.2\bin\pgAgent" INSTALL pgAgent -u
postgres
-p XXXX hostaddr=127.0.0.1 dbname=postgres user=Postgres
* Replace the path of pgAgent if you are not using default
installation path
of Postgres
* Replace XXXX with the password of OS User Postgres (One given while
installing Postgres on windows)
* dbname=postgres (change if your maintenance database is different.)
3) Login using Postgres user account in windows.
4) Try to access pgAdmin III tool in that login. (These two steps are
required to create pgpass.conf file under Postgres login account.)
5) Login back to your normal account.
6) Start pgAgent service using the following command on command prompt
* Net start pgAgent
7) Create a new job using PgAdmin III
8) Under step tab click Add to add new step.
* Specify some name
* Kind - SQL / Batch depending upon the kind of job to be performed.
* Database on which the job is to be performed.
* Definition tab would contain a SQL command if kind selected is SQL
* Definition tab would contain path of Batch file if kind selected is
Batch
9) Under Schedule tab in Job window click Add to add new schedule for
the
job
* Specify some name
* Specify the start date & time
* Specify the end date and time
* Specify days or weekdays, months when the task needs to be
performed in
days tab
* Specify time hours & Minutes when you want the task to be
performed.
(Atleast One hour & minute to be selected.)
* Specify exception if any when you do not want the task to be
performed.
10) All set to work.
---
_ Vishal
>From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
>To: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>,
>"Vishal Arora" <[EMAIL PROTECTED]>,
><[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org>
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Mon, 16 Jul 2007 12:32:15 +0530
>
>
>Dear Vishal,
>
>Sorry ... I didn't recvd any mails from you and Ashish...Kindly send me
>again..
>
>Thanks & Regards
>Jayakumar M
>
>
>________________________________
>
>From: Vishal Arora [mailto:[EMAIL PROTECTED]
>Sent: Mon 7/16/2007 12:27 PM
>To: Jayakumar_Mukundaraju; [EMAIL PROTECTED]
>Subject: RE: [ADMIN] PgAgent Job Scheduling-Backup
>
>
>
>Which place exactly .. I had given you full step by step .. didn't you
>follow that? Be specific.
>
>_ vishal
>
>
> >From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
> >To: "Vishal Arora" <[EMAIL PROTECTED]>,
> ><[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org>
> >Subject: [ADMIN] PgAgent Job Scheduling-Backup
> >Date: Mon, 16 Jul 2007 12:04:10 +0530
> >
> >
> >Dear Vishal, Ashish,
> >
> >Still i am in that place only.. Kindly guide me...Give me some steps,
how
> >to automate the backup..
> >
> >Thanks & Regards
> >Jayakumar M
> >
> >
> >
> >
> >DISCLAIMER:
> >This email (including any attachments) is intended for the sole use of
>the
> >intended recipient/s and may contain material that is CONFIDENTIAL AND
> >PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying
>or
> >distribution or forwarding of any or all of the contents in this
message
>is
> >STRICTLY PROHIBITED. If you are not the intended recipient, please
>contact
> >the sender by email and delete all copies; your cooperation in this
>regard
> >is appreciated.
>
>_________________________________________________________________
>http://im.live.com/messenger/im/home/?source=hmtextlinkjuly07
>
>
>
>
>
>
>DISCLAIMER:
>This email (including any attachments) is intended for the sole use of
the
>intended recipient/s and may contain material that is CONFIDENTIAL AND
>PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
>distribution or forwarding of any or all of the contents in this message
is
>STRICTLY PROHIBITED. If you are not the intended recipient, please
contact
>the sender by email and delete all copies; your cooperation in this
regard
>is appreciated.
_________________________________________________________________
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
_________________________________________________________________
Local listings, incredible imagery, and driving directions - all in one
place! http://maps.live.com/?wip=69&FORM=MGAC01
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate