pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vishal Arora <aroravishal22@hotmail.com>
To: Jayakumar_Mukundaraju@satyam.com
To: ashish.karalkar@info-spectrum.com
To: pgsql-admin@postgresql.org
Subject: Re: PgAgent Job Scheduling-Backup
Date: Mon, 16 Jul 2007 12:41:44 +0000
Message-ID: <BAY123-F159997FCD67D18B0785BC0A9F80@phx.gbl> (raw)
In-Reply-To: <8BE2E1772BEE8D40B0FB9E59DF2A645E04C4E897@hcsmsg002.corp.satyam.ad>


>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: <BAY123-F159997FCD67D18B0785BC0A9F80@phx.gbl>
Permalink:  ../BAY123-F159997FCD67D18B0785BC0A9F80@phx.gbl/
Also on:    postgresql.org/message-id/BAY123-F159997FCD67D18B0785BC0A9F80@phx.gbl

 · 

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: aroravishal22@hotmail.com, Jayakumar_Mukundaraju@satyam.com, ashish.karalkar@info-spectrum.com
  Subject: Re: PgAgent Job Scheduling-Backup
  In-Reply-To: <BAY123-F159997FCD67D18B0785BC0A9F80@phx.gbl>

* 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