Re: PgAgent Job Scheduling-Backup

Dear Vishal and Ashish,

In pgpass.config file i have two login and two passwords..both the password was same.. shall remove one password..

I think i installed pgAgent is wrong ... I disabled the pgAgent service.. Now i am removing that pgAgent and trying to reintall it...

Thanks & Regards
Jayakumar M

________________________________

From: Vishal Arora [mailto:aroravishal22(at)hotmail(dot)com]
Sent: Mon 7/16/2007 2:36 PM
To: ashish(dot)karalkar(at)info-spectrum(dot)com; Jayakumar_Mukundaraju
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup

Ashish - there are time when I don't understand the way these things behave.
These steps are what I exactly followed after breaking my head and Tom Lane'
s head into it. I found that pgpass.conf file if manually created does not
work the way we expect. then I tried to get it created automatically. and
Look it worked. :)

- Vishal

>From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
>To: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>,
><Jayakumar_Mukundaraju(at)satyam(dot)com>
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Mon, 16 Jul 2007 13:22:06 +0530
>
>
>
>Hey Thanks Vishal , its working fine,
>the problem was with pgpass file,
>Jay: following steps are accurate .
>
>
>Vishal: I dont understand one thing I have created same pgpass file and
>kept in the postgress application data manualy the owner was also postgres
>but then it was not taking it effect.after deleteing it and starting
>pgadmin with windows login as postgres user , the file started working,
>why?
>
>
>
>With Regards
>Ashish...
>
>
>
>
>
>
>
>
>----- Original Message ----- From: "Vishal Arora"
><aroravishal22(at)hotmail(dot)com>
>To: <Jayakumar_Mukundaraju(at)satyam(dot)com>;
><ashish(dot)karalkar(at)info-spectrum(dot)com>; <pgsql-admin(at)postgresql(dot)org>
>Sent: Monday, July 16, 2007 12:38 PM
>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(at)satyam(dot)com>
>>>To: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju(at)satyam(dot)com>, "Vishal
>>>Arora" <aroravishal22(at)hotmail(dot)com>, <ashish(dot)karalkar(at)info-spectrum(dot)com>,
>>><pgsql-admin(at)postgresql(dot)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(at)hotmail(dot)com]
>>>Sent: Mon 7/16/2007 12:27 PM
>>>To: Jayakumar_Mukundaraju; ashish(dot)karalkar(at)info-spectrum(dot)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(at)satyam(dot)com>
>>> >To: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>,
>>> ><ashish(dot)karalkar(at)info-spectrum(dot)com>, <pgsql-admin(at)postgresql(dot)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
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 7: You can help support the PostgreSQL project by donating at
>>
>> http://www.postgresql.org/about/donate
>

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