Thread: Re: PgAgent Job Scheduling-Backup

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..

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" <Jayakumar_Mukundaraju@satyam.com>
>To: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>,
>"Vishal Arora" <aroravishal22@hotmail.com>,
><ashish.karalkar@info-spectrum.com>, <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:aroravishal22@hotmail.com]
>Sent: Mon 7/16/2007 12:27 PM
>To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com
>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" <Jayakumar_Mukundaraju@satyam.com>
> >To: "Vishal Arora" <aroravishal22@hotmail.com>,
> ><ashish.karalkar@info-spectrum.com>, <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..

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..

>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>To: "Vishal Arora" <aroravishal22@hotmail.com>,
><ashish.karalkar@info-spectrum.com>, <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:aroravishal22@hotmail.com]
>Sent: Mon 7/16/2007 12:38 PM
>To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com;
>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" <Jayakumar_Mukundaraju@satyam.com>
> >To: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>,
> >"Vishal Arora" <aroravishal22@hotmail.com>,
> ><ashish.karalkar@info-spectrum.com>, <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:aroravishal22@hotmail.com]
> >Sent: Mon 7/16/2007 12:27 PM
> >To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com
> >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" <Jayakumar_Mukundaraju@satyam.com>
> > >To: "Vishal Arora" <aroravishal22@hotmail.com>,
> > ><ashish.karalkar@info-spectrum.com>, <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

Your service is not starting, check you have given proper password while
installing pgAgent service.
the password should be OS password for postgres user and not the database
user password

----- Original Message -----
From: "Vishal Arora" <aroravishal22@hotmail.com>
To: <Jayakumar_Mukundaraju@satyam.com>; <ashish.karalkar@info-spectrum.com>;
<pgsql-admin@postgresql.org>
Sent: Monday, July 16, 2007 6:11 PM
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup


>
>>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>To: "Vishal Arora" <aroravishal22@hotmail.com>,
>><ashish.karalkar@info-spectrum.com>, <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:aroravishal22@hotmail.com]
>>Sent: Mon 7/16/2007 12:38 PM
>>To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com;
>>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" <Jayakumar_Mukundaraju@satyam.com>
>> >To: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>,
>> >"Vishal Arora" <aroravishal22@hotmail.com>,
>> ><ashish.karalkar@info-spectrum.com>, <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:aroravishal22@hotmail.com]
>> >Sent: Mon 7/16/2007 12:27 PM
>> >To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com
>> >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" <Jayakumar_Mukundaraju@satyam.com>
>> > >To: "Vishal Arora" <aroravishal22@hotmail.com>,
>> > ><ashish.karalkar@info-spectrum.com>, <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
>

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..

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..

>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>,        "Vishal
>Arora" <aroravishal22@hotmail.com>,        <pgsql-admin@postgresql.org>
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Mon, 16 Jul 2007 19:23:20 +0530
>
>Dear Vishal / Ashish
>
>
>  I did these steps only...
>
>
>
>1.  I get the pgAgent.sql script in pgAdmin III directory , I copied that
>scripts and execute the scripts in my default postgres database.
>
>2.  After, I get the jobs icon in our postgres.
>
>3.  In that jobs icon I given jobs name,schedule name and steps
>
>          In steps tab I given the step name , Enabled,  Database name
>
>     Kind :  SQL ,  On error is:   Fail
>
>    Comment :  postgres backup
>
>In definition box : I given this command  pg_dump postgres
>"D:\AGBACKUP\AG.sql"

Can you run this command in psql prompt as it is shown here? I am repeatedly
telling you that this is not a SQL command. You can not run this while KIND
Is SQL. put this command in Batch file and select Kind as Batch then run it.

>


>
>
>These steps only I did it...
>
>
>Thanks & Regards
>Jayakumar M
>
>
>
>________________________________
>
>From: Jayakumar_Mukundaraju
>Sent: Mon 7/16/2007 6:19 PM
>To: Ashish Karalkar; Vishal Arora; pgsql-admin@postgresql.org
>Subject: RE: [ADMIN] PgAgent Job Scheduling-Backup
>
>
>Dear Vishal/Ashish
>
>In my pgpass.conf file there is two password is there.. both the passwords
>are same
>Host          Port        Database    UserName    Password
>localhost:   5432:     postgres:     postgres:    satyam123$
>localhost:   5432:        *:             postgres:    satyam123$
>
>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.

_________________________________________________________________
Don't get caught with egg on your face. Play Chicktionary!�
http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2

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..

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..

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..

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..

----- Original Message -----

From: Jayakumar_Mukundaraju

To: Ashish Karalkar ; pgsql-admin@postgresql.org

Cc: Vishal Arora

Sent: Tuesday, July 17, 2007 6:46 PM

Subject: RE: PgAgent Job Scheduling-Backup

Dear Vishal, Ashish,

 

In third point u mentioned (

start>>shutdown>>Logoff your machine and login as postgres user (operating system) I tried that, That is not working,because here the domain name is standard so it is checking that user name globely and reject that user name. What is the next step.....

 

The 6th point.. I created that sceduler is running automatically ..

 

The 8th point.. I created one test.bat file and saved that script inthat file..and kept it in D:\test...

and in steps tab in definition place i saved  the         d:\test\test.bat     it.

 

I went pgAdmin III and in tools tab i entered Run Now... It is not running (Not currently running)...  after i went in D:\test folder i seen one test.bat file is there and one SQL file is there..

 

Kindly tell me where i did mistake...

 

Thanks & Regards

Jayakumar M

09963432764

 

---

From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
Sent: Tue 7/17/2007 5:33 PM
To: Jayakumar_Mukundaraju
Cc: Vishal Arora
Subject: Re: PgAgent Job Scheduling-Backup

 

----- Original Message -----

From: Jayakumar_Mukundaraju

To: Vishal Arora ; ashish.karalkar@info-spectrum.com ; pgsql-admin@postgresql.org

Sent: Tuesday, July 17, 2007 5:03 PM

Subject: PgAgent Job Scheduling-Backup

1)      Run PgAgent.sql script in maintenance database (Postgres database by >default).

        I copied that script and executied in Query tool, it is executed and i get that job icon tab.

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

         I installed the pgAgent and it is running..( I checkied in Administrative tool>>Services>>> there PostgreSQL Scheduling Agent >> status is started

   Replace the path of pgAgent if you are not using default installation path of Postgres

   My pgAgent path is C:\Program FIles\PostgreSQL\8.2\bin\pgAgent

    Replace XXXX with the password of OS User Postgres (One given while installing Postgres on windows) ????

This is the password of postgres operating system user(Windows ) not the database user postgres.

      dbname=postgres (change if your maintenance database is different.)

      my Maintenance database is postgres.
3)      Login using Postgres user account in windows. ?????

 

start>>shutdown>>Logoff your machine and login as postgres user (operating system)

4)      Try to access pgAdmin III tool in that login. (These two steps are required to create pgpass.conf file under Postgres login account.)

 

start pgadmin and connect to the server with postgres database user (This will creat automatic pgpass.conf)

         In pgpass file i have two logins and password, one is server login and another is Account name and password
5)      Login back to your normal account.???

 

start>>shutdown>>log off postgres and lagin as a regular user

 

 

6)      Start pgAgent service using the following command on command prompt    Net start pgAgent

 

c:\net start pgAgent

 

        The command promopt is psql to postgresl prompt... postgres-# i entered       Net start pgAgent.... The cursor comes next line that is  postgres-# prompt

         I entered in  postgres-# pg_dump -f "D:\trial.sql" -apostgres -Upostgres... The cursor comes next line that is postgres-# prompt
7)      Create a new job using PgAdmin III

        Yes i created new jobs name is BACKUP

8)      Under step tab click Add to add new step. :- Yes i created new steps
>*       Specify some name : step name is B1
>*       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 :

 

 

create a batch file containg following text and save it in the directory D:\test\test.bat

@echo off

"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f  D:\test\test.sql -F p -C -d -D postgres 

and in the defination tab of stpe window write "d:\test\test.bat" and save the tab.

 

- In the step tab Definition place i entered  @echo off "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -Upostgres -f D:\test\test.sql -F p -C -d -Dpostgres      @echo on    and saved that tab. 
>*       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  : - I did it i added BK1 as a schedule name
>*       Specify some name
>*       Specify the start date & time :- todays date and time is 30mnts
>*       Specify the end date and time:- tomorrows date and time is 45 mnts
>*       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.

 

Set the time and check the output in d:\test ditrectory

 

This was only i did it.. Kindly guide me  where i went wrong....

 

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..

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..