pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ashish Karalkar <ashish.karalkar@info-spectrum.com>
To: Vishal Arora <aroravishal22@hotmail.com>
To: Jayakumar_Mukundaraju@satyam.com
To: pgsql-admin@postgresql.org
Subject: Re: PgAgent Job Scheduling-Backup
Date: Mon, 16 Jul 2007 18:14:26 +0530
Message-ID: <008101c7c7a7$0f902800$170211ac@LIONKING.COM> (raw)
References: <BAY123-F159997FCD67D18B0785BC0A9F80@phx.gbl>

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
> 




view thread (22+ messages)  latest in thread

Message-ID: <008101c7c7a7$0f902800$170211ac@LIONKING.COM>
Permalink:  ../008101c7c7a7$0f902800$170211ac@LIONKING.COM/
Also on:    postgresql.org/message-id/008101c7c7a7$0f902800$170211ac@LIONKING.COM

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ashish.karalkar@info-spectrum.com, aroravishal22@hotmail.com, Jayakumar_Mukundaraju@satyam.com
  Subject: Re: PgAgent Job Scheduling-Backup
  In-Reply-To: <008101c7c7a7$0f902800$170211ac@LIONKING.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox