Re: PgAgent Job Scheduling-Backup

Dear Vishal, Ashish,

Thanks for the GREAT HELP... I am in Satyam-Hyderabad..Actually i am a Sybase DBA.. My Native is Chennai.. For job sake only i came here.. If any job wise any help, kindly let me know.... I will help u guys... I want to continue this friendship for ever...

Thanks & Regards
Jayakumar M
9963432764

________________________________

From: Vishal Arora [mailto:aroravishal22(at)hotmail(dot)com]
Sent: Tue 7/17/2007 9:47 PM
To: Jayakumar_Mukundaraju
Cc: ashish(dot)karalkar(at)info-spectrum(dot)com
Subject: Re: PgAgent Job Scheduling-Backup

Hey Jay!

Yess if you see a sql file in your system that means your job is complted.
Now when you have scheduled your job to be done only once in a hour so it
would be done again after 1 hr. So be patient. Or if you need to check
increase by selecting minutes more frequently.

Congratulations ! atlast you achieved it.

BTW are u in Bangalore by any chance?

_ vishal

>From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
>To: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju(at)satyam(dot)com>,
><pgsql-admin(at)postgresql(dot)org>
>CC: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>
>Subject: Re: PgAgent Job Scheduling-Backup
>Date: Tue, 17 Jul 2007 19:00:17 +0530
>
>Re: [ADMIN] PgAgent Job Scheduling-BackupJay,
>
> dont login to domain using postgres user login to youe syatem, anyways
>as u see sql file is there means ur job has successfull , its a backup
>file,
>be care full with what are things u want to include in ur backup with
>pg_dump command parametrs in .bat file.
>also the message job is nt currently running means job has alredy done.
> ----- Original Message -----
> From: Jayakumar_Mukundaraju
> To: Ashish Karalkar ; pgsql-admin(at)postgresql(dot)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(dot)karalkar(at)info-spectrum(dot)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(dot)karalkar(at)info-spectrum(dot)com ;
>pgsql-admin(at)postgresql(dot)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..

_________________________________________________________________
http://newlivehotmail.com <http://newlivehotmail.com/>

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.