pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PgAgent Job Scheduling-Backup
22+ messages / 3 participants
[nested] [flat]

* PgAgent Job Scheduling-Backup
@ 2007-07-11 05:23 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-11 09:19 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-11 05:23 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; +Cc: pgsql-admin

Dear Vishal,
I installed job scheduler in postgres windows xp box. I want to schedule a backup job for every day.Kindly give me the solution..
 
Thanks & Regards
Jayakumar M

________________________________

From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Wed 7/11/2007 9:58 AM
To: Jayakumar_Mukundaraju
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PgAgent Job Scheduling



Kindly refer to pgadmin mailing list, I have a list of conversation there.

http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php

Let me know if you can not do it still

_ Plesae put the proper subject in your mail so that it could be related.

- vishal


>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>To: "Vishal Arora" <aroravishal22@hotmail.com>, <lllhman@hotmail.com>
>CC: <pgsql-admin@postgresql.org>
>Subject: Re: [ADMIN] Performance benchmarking
>Date: Tue, 10 Jul 2007 19:07:22 +0530
>
>Dear Vishal,
>
>Thanks for the timely help... I installed jobs scheduler in my windows
>box.. Kindly guide me how to set the job schedule.
>
>Thanks & Regards
>Jayakumar M
>
>
>________________________________
>
>From: pgsql-admin-owner@postgresql.org on behalf of Vishal Arora
>Sent: Fri 7/6/2007 10:25 PM
>To: lllhman@hotmail.com
>Cc: pgsql-admin@postgresql.org
>Subject: Re: [ADMIN] Performance benchmarking
>
>
>
>
>I think you have already got your answer...
>
>NO you do not need any kind of license to use PostgreSQL as it an Open
>Source. You can do anything you want to do.
>
>- Vishal
>
> >From: lai yoke hman <lllhman@hotmail.com>
> >To: <pgsql-admin@postgresql.org>
> >Subject: [ADMIN] Performance benchmarking
> >Date: Fri, 6 Jul 2007 01:02:12 +0000
> >
> >
> >Hello,
> >I am an undergraduate of a university in Malaysia, if I want to do
> >performance benchmark on PostgreSQL 8, do I need to get a license
>agreement
> >or some sort of thing?
> >Thanks.
> >_________________________________________________________________
> >Did you know you can now customize your mailbox with different colours to
> >suit your mood with the new Windows Live Hotmail?
> >http://get.live.com/mail/features
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 7: You can help support the PostgreSQL project by donating at
> >
> >                 http://www.postgresql.org/about/donate
>
>_________________________________________________________________
>Don't get caught with egg on your face. Play Chicktionary!
>http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org <http://archives.postgresql.org/; 
><http://archives.postgresql.org/;
>
>
>
>
>
>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://liveearth.msn.com <http://liveearth.msn.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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-11 05:23 PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-11 09:19 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-11 09:19 UTC (permalink / raw)
  To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>; +Cc: pgsql-admin

No... Waiting for Vishals mail...
 
Thanks & Regards
Jayakumar M

________________________________

From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
Sent: Wed 7/11/2007 1:53 PM
To: Jayakumar_Mukundaraju
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup 


Is your problem solved???
 
With Regards
Ashish...

	----- Original Message ----- 
	From: Jayakumar_Mukundaraju <mailto:Jayakumar_Mukundaraju@satyam.com>  
	To: Vishal Arora <mailto:aroravishal22@hotmail.com>  
	Cc: pgsql-admin@postgresql.org 
	Sent: Wednesday, July 11, 2007 10:53 AM
	Subject: [ADMIN] PgAgent Job Scheduling-Backup 

	Dear Vishal,
	I installed job scheduler in postgres windows xp box. I want to schedule a backup job for every day.Kindly give me the solution..
	 
	Thanks & Regards
	Jayakumar M

________________________________

	From: Vishal Arora [mailto:aroravishal22@hotmail.com]
	Sent: Wed 7/11/2007 9:58 AM
	To: Jayakumar_Mukundaraju
	Cc: pgsql-admin@postgresql.org
	Subject: Re: [ADMIN] PgAgent Job Scheduling
	
	

	Kindly refer to pgadmin mailing list, I have a list of conversation there.
	
	http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php
	
	Let me know if you can not do it still
	
	_ Plesae put the proper subject in your mail so that it could be related.
	
	- vishal
	
	
	>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
	>To: "Vishal Arora" <aroravishal22@hotmail.com>, <lllhman@hotmail.com>
	>CC: <pgsql-admin@postgresql.org>
	>Subject: Re: [ADMIN] Performance benchmarking
	>Date: Tue, 10 Jul 2007 19:07:22 +0530
	>
	>Dear Vishal,
	>
	>Thanks for the timely help... I installed jobs scheduler in my windows
	>box.. Kindly guide me how to set the job schedule.
	>
	>Thanks & Regards
	>Jayakumar M
	>
	>
	>________________________________
	>
	>From: pgsql-admin-owner@postgresql.org on behalf of Vishal Arora
	>Sent: Fri 7/6/2007 10:25 PM
	>To: lllhman@hotmail.com
	>Cc: pgsql-admin@postgresql.org
	>Subject: Re: [ADMIN] Performance benchmarking
	>
	>
	>
	>
	>I think you have already got your answer...
	>
	>NO you do not need any kind of license to use PostgreSQL as it an Open
	>Source. You can do anything you want to do.
	>
	>- Vishal
	>
	> >From: lai yoke hman <lllhman@hotmail.com>
	> >To: <pgsql-admin@postgresql.org>
	> >Subject: [ADMIN] Performance benchmarking
	> >Date: Fri, 6 Jul 2007 01:02:12 +0000
	> >
	> >
	> >Hello,
	> >I am an undergraduate of a university in Malaysia, if I want to do
	> >performance benchmark on PostgreSQL 8, do I need to get a license
	>agreement
	> >or some sort of thing?
	> >Thanks.
	> >_________________________________________________________________
	> >Did you know you can now customize your mailbox with different colours to
	> >suit your mood with the new Windows Live Hotmail?
	> >http://get.live.com/mail/features
	> >
	> >---------------------------(end of broadcast)---------------------------
	> >TIP 7: You can help support the PostgreSQL project by donating at
	> >
	> >                 http://www.postgresql.org/about/donate
	>
	>_________________________________________________________________
	>Don't get caught with egg on your face. Play Chicktionary!
	>http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
	>
	>
	>---------------------------(end of broadcast)---------------------------
	>TIP 4: Have you searched our list archives?
	>
	>                http://archives.postgresql.org <http://archives.postgresql.org/; 
	><http://archives.postgresql.org/;
	>
	>
	>
	>
	>
	>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://liveearth.msn.com <http://liveearth.msn.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..



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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* PgAgent Job Scheduling-Backup
@ 2007-07-12 04:28 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-12 04:28 UTC (permalink / raw)
  To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>; pgsql-admin

Dear Ashish,
 
So far i didn't get the solution, I herewith attched what i given in jobs scheduler. Kindly look into it..
 
This is in Jobs window
Name                                      J1
ID                                           6
Enabled                                  Yes
Host Agent  
Job class                                Routine Maintenance
Created                                  7/11/2007 11.39.52AM
Changed                                7/11/2007 11.39.52AM
Next run                                7/12/2007 9.34.14AM
Last run 
Last result                              Unknown
Running at                             Not currently running
Comment                              This is job1  
 
This is in Schedule window
Properties
Name                                    s1
Id                                          13
Enabled                                 Yes
start                                      Date/Time
End                                       Date/Time

This is in Steps window
Property                                value 
Name                                     s1  
ID                                          17
Enabled                                 Yes
Kind                                      SQL
Database                               Postgres
code                                     C:\Backup\AG
On error                                 Fail
Comment

Thanks & Regards
Jayakumar M

 
________________________________

From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
Sent: Wed 7/11/2007 5:02 PM
To: Vishal Arora; Jayakumar_Mukundaraju
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup



Yes,
 Jaya Kumar everthing is there on mailing list archive, still you face let
us know.

With Regards
Ashish...

----- Original Message -----
From: "Vishal Arora" <aroravishal22@hotmail.com>
To: <Jayakumar_Mukundaraju@satyam.com>
Cc: <ashish.karalkar@info-spectrum.com>
Sent: Wednesday, July 11, 2007 4:30 PM
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup


>
> Hi Jayakumar,
>
> I have already told you to see the the mailing list. If you are not able
> to solve it still let me know and tell me where exactly you are facing the
> problem.
>
> - Vishal
>
>>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>>CC: <pgsql-admin@postgresql.org>
>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup Date: Wed, 11 Jul 2007
>>14:49:59 +0530
>>
>>No... Waiting for Vishals mail...
>>
>>Thanks & Regards
>>Jayakumar M
>>
>>________________________________
>>
>>From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
>>Sent: Wed 7/11/2007 1:53 PM
>>To: Jayakumar_Mukundaraju
>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>
>>
>>Is your problem solved???
>>
>>With Regards
>>Ashish...
>>
>> ----- Original Message -----
>> From: Jayakumar_Mukundaraju <mailto:Jayakumar_Mukundaraju@satyam.com>
>> To: Vishal Arora <mailto:aroravishal22@hotmail.com>
>> Cc: pgsql-admin@postgresql.org
>> Sent: Wednesday, July 11, 2007 10:53 AM
>> Subject: [ADMIN] PgAgent Job Scheduling-Backup
>>
>> Dear Vishal,
>> I installed job scheduler in postgres windows xp box. I want to schedule
>> a backup job for every day.Kindly give me the solution..
>>
>> Thanks & Regards
>> Jayakumar M
>>
>>________________________________
>>
>> From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>> Sent: Wed 7/11/2007 9:58 AM
>> To: Jayakumar_Mukundaraju
>> Cc: pgsql-admin@postgresql.org
>> Subject: Re: [ADMIN] PgAgent Job Scheduling
>>
>>
>>
>> Kindly refer to pgadmin mailing list, I have a list of conversation
>> there.
>>
>> http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php
>>
>> Let me know if you can not do it still
>>
>> _ Plesae put the proper subject in your mail so that it could be related.
>>
>> - vishal
>>
>>
>> >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>> >To: "Vishal Arora" <aroravishal22@hotmail.com>, <lllhman@hotmail.com>
>> >CC: <pgsql-admin@postgresql.org>
>> >Subject: Re: [ADMIN] Performance benchmarking
>> >Date: Tue, 10 Jul 2007 19:07:22 +0530
>> >
>> >Dear Vishal,
>> >
>> >Thanks for the timely help... I installed jobs scheduler in my windows
>> >box.. Kindly guide me how to set the job schedule.
>> >
>> >Thanks & Regards
>> >Jayakumar M
>> >
>> >
>> >________________________________
>> >
>> >From: pgsql-admin-owner@postgresql.org on behalf of Vishal Arora
>> >Sent: Fri 7/6/2007 10:25 PM
>> >To: lllhman@hotmail.com
>> >Cc: pgsql-admin@postgresql.org
>> >Subject: Re: [ADMIN] Performance benchmarking
>> >
>> >
>> >
>> >
>> >I think you have already got your answer...
>> >
>> >NO you do not need any kind of license to use PostgreSQL as it an Open
>> >Source. You can do anything you want to do.
>> >
>> >- Vishal
>> >
>> > >From: lai yoke hman <lllhman@hotmail.com>
>> > >To: <pgsql-admin@postgresql.org>
>> > >Subject: [ADMIN] Performance benchmarking
>> > >Date: Fri, 6 Jul 2007 01:02:12 +0000
>> > >
>> > >
>> > >Hello,
>> > >I am an undergraduate of a university in Malaysia, if I want to do
>> > >performance benchmark on PostgreSQL 8, do I need to get a license
>> >agreement
>> > >or some sort of thing?
>> > >Thanks.
>> > >_________________________________________________________________
>> > >Did you know you can now customize your mailbox with different colours
>>to
>> > >suit your mood with the new Windows Live Hotmail?
>> > >http://get.live.com/mail/features
>> > >
>> > >---------------------------(end of
>>broadcast)---------------------------
>> > >TIP 7: You can help support the PostgreSQL project by donating at
>> > >
>> > >                 http://www.postgresql.org/about/donate
>> >
>> >_________________________________________________________________
>> >Don't get caught with egg on your face. Play Chicktionary!
>> >http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
>> >
>> >
>> >---------------------------(end of broadcast)---------------------------
>> >TIP 4: Have you searched our list archives?
>> >
>> >                http://archives.postgresql.org <http://archives.postgresql.org/; 
>><http://archives.postgresql.org/;
>> ><http://archives.postgresql.org/;
>> >
>> >
>> >
>> >
>> >
>> >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://liveearth.msn.com <http://liveearth.msn.com/;  <http://liveearth.msn.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..
>>
>>
>>
>>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.
>
> _________________________________________________________________
> Need a brain boost? Recharge with a stimulating game. Play now!
> http://club.live.com/home.aspx?icid=club_hotmailtextlink1
>






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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
@ 2007-07-13 04:44 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 06:34 ` PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-13 04:44 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

Dear Vishal,
 
Still i am in that place only.. Kindly guide me...Give me some steps, how to automate the backup..
 
Thanks & Regards
Jayakumar M

________________________________

From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Fri 7/13/2007 9:38 AM
To: ashish.karalkar@info-spectrum.com; Jayakumar_Mukundaraju
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup



Hi Ashish & Jayakumar,

I hope your problem is sloved now.

- Vishal


>From: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>To: "Vishal Arora" <aroravishal22@hotmail.com>,       
><Jayakumar_Mukundaraju@satyam.com>
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Wed, 11 Jul 2007 17:34:27 +0530
>
>Hello Vishal,
>
>I am having Windows XP, PostgreSQL 8.2 server running on my local machine.
>
>All job is set  but its not running on schedule time.
>
>I have given command:
>
>pg_dump -f D:\trial.sql  -a postgres -U postgres
>
>in the >>step>>defination tab
>
>could you please suggest what is going wrong
>
>With regards
>Ashish...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>----- Original Message ----- From: "Vishal Arora"
><aroravishal22@hotmail.com>
>To: <Jayakumar_Mukundaraju@satyam.com>
>Cc: <ashish.karalkar@info-spectrum.com>
>Sent: Wednesday, July 11, 2007 4:30 PM
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>
>
>>
>>Hi Jayakumar,
>>
>>I have already told you to see the the mailing list. If you are not able
>>to solve it still let me know and tell me where exactly you are facing the
>>problem.
>>
>>- Vishal
>>
>>>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>>To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>>>CC: <pgsql-admin@postgresql.org>
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup Date: Wed, 11 Jul 2007
>>>14:49:59 +0530
>>>
>>>No... Waiting for Vishals mail...
>>>
>>>Thanks & Regards
>>>Jayakumar M
>>>
>>>________________________________
>>>
>>>From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
>>>Sent: Wed 7/11/2007 1:53 PM
>>>To: Jayakumar_Mukundaraju
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>
>>>
>>>Is your problem solved???
>>>
>>>With Regards
>>>Ashish...
>>>
>>>----- Original Message -----
>>>From: Jayakumar_Mukundaraju <mailto:Jayakumar_Mukundaraju@satyam.com>
>>>To: Vishal Arora <mailto:aroravishal22@hotmail.com>
>>>Cc: pgsql-admin@postgresql.org
>>>Sent: Wednesday, July 11, 2007 10:53 AM
>>>Subject: [ADMIN] PgAgent Job Scheduling-Backup
>>>
>>>Dear Vishal,
>>>I installed job scheduler in postgres windows xp box. I want to schedule
>>>a backup job for every day.Kindly give me the solution..
>>>
>>>Thanks & Regards
>>>Jayakumar M
>>>
>>>________________________________
>>>
>>>From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>>>Sent: Wed 7/11/2007 9:58 AM
>>>To: Jayakumar_Mukundaraju
>>>Cc: pgsql-admin@postgresql.org
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling
>>>
>>>
>>>
>>>Kindly refer to pgadmin mailing list, I have a list of conversation
>>>there.
>>>
>>>http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php
>>>
>>>Let me know if you can not do it still
>>>
>>>_ Plesae put the proper subject in your mail so that it could be related.
>>>
>>>- vishal
>>>
>>>
>>> >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>> >To: "Vishal Arora" <aroravishal22@hotmail.com>, <lllhman@hotmail.com>
>>> >CC: <pgsql-admin@postgresql.org>
>>> >Subject: Re: [ADMIN] Performance benchmarking
>>> >Date: Tue, 10 Jul 2007 19:07:22 +0530
>>> >
>>> >Dear Vishal,
>>> >
>>> >Thanks for the timely help... I installed jobs scheduler in my windows
>>> >box.. Kindly guide me how to set the job schedule.
>>> >
>>> >Thanks & Regards
>>> >Jayakumar M
>>> >
>>> >
>>> >________________________________
>>> >
>>> >From: pgsql-admin-owner@postgresql.org on behalf of Vishal Arora
>>> >Sent: Fri 7/6/2007 10:25 PM
>>> >To: lllhman@hotmail.com
>>> >Cc: pgsql-admin@postgresql.org
>>> >Subject: Re: [ADMIN] Performance benchmarking
>>> >
>>> >
>>> >
>>> >
>>> >I think you have already got your answer...
>>> >
>>> >NO you do not need any kind of license to use PostgreSQL as it an Open
>>> >Source. You can do anything you want to do.
>>> >
>>> >- Vishal
>>> >
>>> > >From: lai yoke hman <lllhman@hotmail.com>
>>> > >To: <pgsql-admin@postgresql.org>
>>> > >Subject: [ADMIN] Performance benchmarking
>>> > >Date: Fri, 6 Jul 2007 01:02:12 +0000
>>> > >
>>> > >
>>> > >Hello,
>>> > >I am an undergraduate of a university in Malaysia, if I want to do
>>> > >performance benchmark on PostgreSQL 8, do I need to get a license
>>> >agreement
>>> > >or some sort of thing?
>>> > >Thanks.
>>> > >_________________________________________________________________
>>> > >Did you know you can now customize your mailbox with different
>>>colours
>>>to
>>> > >suit your mood with the new Windows Live Hotmail?
>>> > >http://get.live.com/mail/features
>>> > >
>>> > >---------------------------(end of
>>>broadcast)---------------------------
>>> > >TIP 7: You can help support the PostgreSQL project by donating at
>>> > >
>>> > >                 http://www.postgresql.org/about/donate
>>> >
>>> >_________________________________________________________________
>>> >Don't get caught with egg on your face. Play Chicktionary!
>>> >http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
>>> >
>>> >
>>> >---------------------------(end of
>>>broadcast)---------------------------
>>> >TIP 4: Have you searched our list archives?
>>> >
>>> >                http://archives.postgresql.org <http://archives.postgresql.org/; 
>>><http://archives.postgresql.org/;
>>> ><http://archives.postgresql.org/;
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >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://liveearth.msn.com <http://liveearth.msn.com/;  <http://liveearth.msn.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..
>>>
>>>
>>>
>>>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.
>>
>>_________________________________________________________________
>>Need a brain boost? Recharge with a stimulating game. Play now!
>>http://club.live.com/home.aspx?icid=club_hotmailtextlink1
>>
>

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

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* PgAgent Job Scheduling-Backup
  2007-07-13 04:44 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-16 06:34 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-16 06:34 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

 
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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
@ 2007-07-13 05:56 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-13 07:16 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-13 05:56 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

Dear Ashish,
 
Congrats... I am trying that only.. Kindly give me the sql command use used..
 
Thanks & Regards
Jayakumar M
 

________________________________

From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Fri 7/13/2007 10:59 AM
To: ashish.karalkar@info-spectrum.com
Cc: Jayakumar_Mukundaraju
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup



Hi Ashish

Can you please show me your batch file?

- Vishal


>From: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>To: "Vishal Arora" <aroravishal22@hotmail.com>
>CC: <Jayakumar_Mukundaraju@satyam.com>
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Thu, 12 Jul 2007 16:22:05 +0530
>
>Hello Vishal,
>
>Now I have test my Job with sql command directly in the defination window
>of "step"
>Its working fine on schedule.
>
>Now I want to run the batch file so I changed "step" kind to batch
>and in the defination window gave the path to batch file as
>D:\test\test1.bat
>
>This bat file contains instruction for taking backup(pg_dump etc) and is
>working fine from prompt directly.
>
>But in pgAgent it is called and status is shown successfull,
>output says C:\windows\win32>D:\test\test1.bat
>
>but the batch file is not processed.
>I think I am doing somthing wrong in calling the batch file but just nott
>able to figure out.
>an you please suggest where am i missing
>
>With Regards
>Ashish
>
>
>
>----- Original Message ----- From: "Vishal Arora"
><aroravishal22@hotmail.com>
>To: <ashish.karalkar@info-spectrum.com>; <Jayakumar_Mukundaraju@satyam.com>
>Sent: Thursday, July 12, 2007 9:35 AM
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>
>
>>HI Ashish,,
>>
>>what is the kind of step you have selected. pg_dump is not a SQL kind of
>>query. If you need to use pg_dump make a batch file and call that batch
>>file in the step selecting the kind as Batch.
>>
>>BTW did you see the mailing list.
>>
>>- Vishal
>>
>>
>>>From: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>>>To: "Vishal Arora" <aroravishal22@hotmail.com>,
>>><Jayakumar_Mukundaraju@satyam.com>
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>Date: Wed, 11 Jul 2007 17:34:27 +0530
>>>
>>>Hello Vishal,
>>>
>>>I am having Windows XP, PostgreSQL 8.2 server running on my local
>>>machine.
>>>
>>>All job is set  but its not running on schedule time.
>>>
>>>I have given command:
>>>
>>>pg_dump -f D:\trial.sql  -a postgres -U postgres
>>>
>>>in the >>step>>defination tab
>>>
>>>could you please suggest what is going wrong
>>>
>>>With regards
>>>Ashish...
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>----- Original Message ----- From: "Vishal Arora"
>>><aroravishal22@hotmail.com>
>>>To: <Jayakumar_Mukundaraju@satyam.com>
>>>Cc: <ashish.karalkar@info-spectrum.com>
>>>Sent: Wednesday, July 11, 2007 4:30 PM
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>
>>>
>>>>
>>>>Hi Jayakumar,
>>>>
>>>>I have already told you to see the the mailing list. If you are not able
>>>>to solve it still let me know and tell me where exactly you are facing
>>>>the problem.
>>>>
>>>>- Vishal
>>>>
>>>>>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>>>>To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>>>>>CC: <pgsql-admin@postgresql.org>
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup Date: Wed, 11 Jul
>>>>>2007 14:49:59 +0530
>>>>>
>>>>>No... Waiting for Vishals mail...
>>>>>
>>>>>Thanks & Regards
>>>>>Jayakumar M
>>>>>
>>>>>________________________________
>>>>>
>>>>>From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
>>>>>Sent: Wed 7/11/2007 1:53 PM
>>>>>To: Jayakumar_Mukundaraju
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>>>
>>>>>
>>>>>Is your problem solved???
>>>>>
>>>>>With Regards
>>>>>Ashish...
>>>>>
>>>>>----- Original Message -----
>>>>>From: Jayakumar_Mukundaraju <mailto:Jayakumar_Mukundaraju@satyam.com>
>>>>>To: Vishal Arora <mailto:aroravishal22@hotmail.com>
>>>>>Cc: pgsql-admin@postgresql.org
>>>>>Sent: Wednesday, July 11, 2007 10:53 AM
>>>>>Subject: [ADMIN] PgAgent Job Scheduling-Backup
>>>>>
>>>>>Dear Vishal,
>>>>>I installed job scheduler in postgres windows xp box. I want to
>>>>>schedule a backup job for every day.Kindly give me the solution..
>>>>>
>>>>>Thanks & Regards
>>>>>Jayakumar M
>>>>>
>>>>>________________________________
>>>>>
>>>>>From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>>>>>Sent: Wed 7/11/2007 9:58 AM
>>>>>To: Jayakumar_Mukundaraju
>>>>>Cc: pgsql-admin@postgresql.org
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling
>>>>>
>>>>>
>>>>>
>>>>>Kindly refer to pgadmin mailing list, I have a list of conversation
>>>>>there.
>>>>>
>>>>>http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php
>>>>>
>>>>>Let me know if you can not do it still
>>>>>
>>>>>_ Plesae put the proper subject in your mail so that it could be
>>>>>related.
>>>>>
>>>>>- vishal
>>>>>
>>>>>
>>>>> >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>>>> >To: "Vishal Arora" <aroravishal22@hotmail.com>, <lllhman@hotmail.com>
>>>>> >CC: <pgsql-admin@postgresql.org>
>>>>> >Subject: Re: [ADMIN] Performance benchmarking
>>>>> >Date: Tue, 10 Jul 2007 19:07:22 +0530
>>>>> >
>>>>> >Dear Vishal,
>>>>> >
>>>>> >Thanks for the timely help... I installed jobs scheduler in my
>>>>>windows
>>>>> >box.. Kindly guide me how to set the job schedule.
>>>>> >
>>>>> >Thanks & Regards
>>>>> >Jayakumar M
>>>>> >
>>>>> >
>>>>> >________________________________
>>>>> >
>>>>> >From: pgsql-admin-owner@postgresql.org on behalf of Vishal Arora
>>>>> >Sent: Fri 7/6/2007 10:25 PM
>>>>> >To: lllhman@hotmail.com
>>>>> >Cc: pgsql-admin@postgresql.org
>>>>> >Subject: Re: [ADMIN] Performance benchmarking
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >I think you have already got your answer...
>>>>> >
>>>>> >NO you do not need any kind of license to use PostgreSQL as it an
>>>>>Open
>>>>> >Source. You can do anything you want to do.
>>>>> >
>>>>> >- Vishal
>>>>> >
>>>>> > >From: lai yoke hman <lllhman@hotmail.com>
>>>>> > >To: <pgsql-admin@postgresql.org>
>>>>> > >Subject: [ADMIN] Performance benchmarking
>>>>> > >Date: Fri, 6 Jul 2007 01:02:12 +0000
>>>>> > >
>>>>> > >
>>>>> > >Hello,
>>>>> > >I am an undergraduate of a university in Malaysia, if I want to do
>>>>> > >performance benchmark on PostgreSQL 8, do I need to get a license
>>>>> >agreement
>>>>> > >or some sort of thing?
>>>>> > >Thanks.
>>>>> > >_________________________________________________________________
>>>>> > >Did you know you can now customize your mailbox with different
>>>>>colours
>>>>>to
>>>>> > >suit your mood with the new Windows Live Hotmail?
>>>>> > >http://get.live.com/mail/features
>>>>> > >
>>>>> > >---------------------------(end of
>>>>>broadcast)---------------------------
>>>>> > >TIP 7: You can help support the PostgreSQL project by donating at
>>>>> > >
>>>>> > >                 http://www.postgresql.org/about/donate
>>>>> >
>>>>> >_________________________________________________________________
>>>>> >Don't get caught with egg on your face. Play Chicktionary!
>>>>> >http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
>>>>> >
>>>>> >
>>>>> >---------------------------(end of
>>>>>broadcast)---------------------------
>>>>> >TIP 4: Have you searched our list archives?
>>>>> >
>>>>> >                http://archives.postgresql.org <http://archives.postgresql.org/; 
>>>>><http://archives.postgresql.org/;
>>>>> ><http://archives.postgresql.org/;
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >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://liveearth.msn.com <http://liveearth.msn.com/;  <http://liveearth.msn.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..
>>>>>
>>>>>
>>>>>
>>>>>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.
>>>>
>>>>_________________________________________________________________
>>>>Need a brain boost? Recharge with a stimulating game. Play now!
>>>>http://club.live.com/home.aspx?icid=club_hotmailtextlink1
>>>>
>>>
>>
>>_________________________________________________________________
>>http://liveearth.msn.com <http://liveearth.msn.com/; 
>>
>

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

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-13 05:56 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-13 07:16 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-13 07:16 UTC (permalink / raw)
  To: Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>; Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

Dear Ashish,
 
I waiting for your mail...
 
Thanks & Regards
Jayakumar M
 

________________________________

From: Jayakumar_Mukundaraju
Sent: Fri 7/13/2007 11:26 AM
To: Vishal Arora; ashish.karalkar@info-spectrum.com; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] PgAgent Job Scheduling-Backup


Dear Ashish,
 
Congrats... I am trying that only.. Kindly give me the sql command use used..
 
Thanks & Regards
Jayakumar M
 

________________________________

From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Fri 7/13/2007 10:59 AM
To: ashish.karalkar@info-spectrum.com
Cc: Jayakumar_Mukundaraju
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup



Hi Ashish

Can you please show me your batch file?

- Vishal


>From: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>To: "Vishal Arora" <aroravishal22@hotmail.com>
>CC: <Jayakumar_Mukundaraju@satyam.com>
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Thu, 12 Jul 2007 16:22:05 +0530
>
>Hello Vishal,
>
>Now I have test my Job with sql command directly in the defination window
>of "step"
>Its working fine on schedule.
>
>Now I want to run the batch file so I changed "step" kind to batch
>and in the defination window gave the path to batch file as
>D:\test\test1.bat
>
>This bat file contains instruction for taking backup(pg_dump etc) and is
>working fine from prompt directly.
>
>But in pgAgent it is called and status is shown successfull,
>output says C:\windows\win32>D:\test\test1.bat
>
>but the batch file is not processed.
>I think I am doing somthing wrong in calling the batch file but just nott
>able to figure out.
>an you please suggest where am i missing
>
>With Regards
>Ashish
>
>
>
>----- Original Message ----- From: "Vishal Arora"
><aroravishal22@hotmail.com>
>To: <ashish.karalkar@info-spectrum.com>; <Jayakumar_Mukundaraju@satyam.com>
>Sent: Thursday, July 12, 2007 9:35 AM
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>
>
>>HI Ashish,,
>>
>>what is the kind of step you have selected. pg_dump is not a SQL kind of
>>query. If you need to use pg_dump make a batch file and call that batch
>>file in the step selecting the kind as Batch.
>>
>>BTW did you see the mailing list.
>>
>>- Vishal
>>
>>
>>>From: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>>>To: "Vishal Arora" <aroravishal22@hotmail.com>,
>>><Jayakumar_Mukundaraju@satyam.com>
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>Date: Wed, 11 Jul 2007 17:34:27 +0530
>>>
>>>Hello Vishal,
>>>
>>>I am having Windows XP, PostgreSQL 8.2 server running on my local
>>>machine.
>>>
>>>All job is set  but its not running on schedule time.
>>>
>>>I have given command:
>>>
>>>pg_dump -f D:\trial.sql  -a postgres -U postgres
>>>
>>>in the >>step>>defination tab
>>>
>>>could you please suggest what is going wrong
>>>
>>>With regards
>>>Ashish...
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>----- Original Message ----- From: "Vishal Arora"
>>><aroravishal22@hotmail.com>
>>>To: <Jayakumar_Mukundaraju@satyam.com>
>>>Cc: <ashish.karalkar@info-spectrum.com>
>>>Sent: Wednesday, July 11, 2007 4:30 PM
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>
>>>
>>>>
>>>>Hi Jayakumar,
>>>>
>>>>I have already told you to see the the mailing list. If you are not able
>>>>to solve it still let me know and tell me where exactly you are facing
>>>>the problem.
>>>>
>>>>- Vishal
>>>>
>>>>>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>>>>To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
>>>>>CC: <pgsql-admin@postgresql.org>
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup Date: Wed, 11 Jul
>>>>>2007 14:49:59 +0530
>>>>>
>>>>>No... Waiting for Vishals mail...
>>>>>
>>>>>Thanks & Regards
>>>>>Jayakumar M
>>>>>
>>>>>________________________________
>>>>>
>>>>>From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
>>>>>Sent: Wed 7/11/2007 1:53 PM
>>>>>To: Jayakumar_Mukundaraju
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>>>
>>>>>
>>>>>Is your problem solved???
>>>>>
>>>>>With Regards
>>>>>Ashish...
>>>>>
>>>>>----- Original Message -----
>>>>>From: Jayakumar_Mukundaraju <mailto:Jayakumar_Mukundaraju@satyam.com>
>>>>>To: Vishal Arora <mailto:aroravishal22@hotmail.com>
>>>>>Cc: pgsql-admin@postgresql.org
>>>>>Sent: Wednesday, July 11, 2007 10:53 AM
>>>>>Subject: [ADMIN] PgAgent Job Scheduling-Backup
>>>>>
>>>>>Dear Vishal,
>>>>>I installed job scheduler in postgres windows xp box. I want to
>>>>>schedule a backup job for every day.Kindly give me the solution..
>>>>>
>>>>>Thanks & Regards
>>>>>Jayakumar M
>>>>>
>>>>>________________________________
>>>>>
>>>>>From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>>>>>Sent: Wed 7/11/2007 9:58 AM
>>>>>To: Jayakumar_Mukundaraju
>>>>>Cc: pgsql-admin@postgresql.org
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling
>>>>>
>>>>>
>>>>>
>>>>>Kindly refer to pgadmin mailing list, I have a list of conversation
>>>>>there.
>>>>>
>>>>>http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php
>>>>>
>>>>>Let me know if you can not do it still
>>>>>
>>>>>_ Plesae put the proper subject in your mail so that it could be
>>>>>related.
>>>>>
>>>>>- vishal
>>>>>
>>>>>
>>>>> >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
>>>>> >To: "Vishal Arora" <aroravishal22@hotmail.com>, <lllhman@hotmail.com>
>>>>> >CC: <pgsql-admin@postgresql.org>
>>>>> >Subject: Re: [ADMIN] Performance benchmarking
>>>>> >Date: Tue, 10 Jul 2007 19:07:22 +0530
>>>>> >
>>>>> >Dear Vishal,
>>>>> >
>>>>> >Thanks for the timely help... I installed jobs scheduler in my
>>>>>windows
>>>>> >box.. Kindly guide me how to set the job schedule.
>>>>> >
>>>>> >Thanks & Regards
>>>>> >Jayakumar M
>>>>> >
>>>>> >
>>>>> >________________________________
>>>>> >
>>>>> >From: pgsql-admin-owner@postgresql.org on behalf of Vishal Arora
>>>>> >Sent: Fri 7/6/2007 10:25 PM
>>>>> >To: lllhman@hotmail.com
>>>>> >Cc: pgsql-admin@postgresql.org
>>>>> >Subject: Re: [ADMIN] Performance benchmarking
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >I think you have already got your answer...
>>>>> >
>>>>> >NO you do not need any kind of license to use PostgreSQL as it an
>>>>>Open
>>>>> >Source. You can do anything you want to do.
>>>>> >
>>>>> >- Vishal
>>>>> >
>>>>> > >From: lai yoke hman <lllhman@hotmail.com>
>>>>> > >To: <pgsql-admin@postgresql.org>
>>>>> > >Subject: [ADMIN] Performance benchmarking
>>>>> > >Date: Fri, 6 Jul 2007 01:02:12 +0000
>>>>> > >
>>>>> > >
>>>>> > >Hello,
>>>>> > >I am an undergraduate of a university in Malaysia, if I want to do
>>>>> > >performance benchmark on PostgreSQL 8, do I need to get a license
>>>>> >agreement
>>>>> > >or some sort of thing?
>>>>> > >Thanks.
>>>>> > >_________________________________________________________________
>>>>> > >Did you know you can now customize your mailbox with different
>>>>>colours
>>>>>to
>>>>> > >suit your mood with the new Windows Live Hotmail?
>>>>> > >http://get.live.com/mail/features
>>>>> > >
>>>>> > >---------------------------(end of
>>>>>broadcast)---------------------------
>>>>> > >TIP 7: You can help support the PostgreSQL project by donating at
>>>>> > >
>>>>> > >                 http://www.postgresql.org/about/donate
>>>>> >
>>>>> >_________________________________________________________________
>>>>> >Don't get caught with egg on your face. Play Chicktionary!
>>>>> >http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
>>>>> >
>>>>> >
>>>>> >---------------------------(end of
>>>>>broadcast)---------------------------
>>>>> >TIP 4: Have you searched our list archives?
>>>>> >
>>>>> >                http://archives.postgresql.org <http://archives.postgresql.org/; 
>>>>><http://archives.postgresql.org/;
>>>>> ><http://archives.postgresql.org/;
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >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://liveearth.msn.com <http://liveearth.msn.com/;  <http://liveearth.msn.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..
>>>>>
>>>>>
>>>>>
>>>>>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.
>>>>
>>>>_________________________________________________________________
>>>>Need a brain boost? Recharge with a stimulating game. Play now!
>>>>http://club.live.com/home.aspx?icid=club_hotmailtextlink1
>>>>
>>>
>>
>>_________________________________________________________________
>>http://liveearth.msn.com <http://liveearth.msn.com/; 
>>
>

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

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
@ 2007-07-16 07:02 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-16 07:02 UTC (permalink / raw)
  To: Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>; Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

 
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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
@ 2007-07-16 07:08 Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Vishal Arora @ 2007-07-16 07:08 UTC (permalink / raw)
  To: Jayakumar_Mukundaraju@satyam.com; ashish.karalkar@info-spectrum.com; pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
@ 2007-07-16 11:51 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-16 11:51 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

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), 
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
*       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
*       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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-16 12:41   ` Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 12:44     ` Re: PgAgent Job Scheduling-Backup Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  2007-07-17 05:01     ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-17 11:33     ` PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 3 replies; 22+ messages in thread

From: Vishal Arora @ 2007-07-16 12:41 UTC (permalink / raw)
  To: Jayakumar_Mukundaraju@satyam.com; ashish.karalkar@info-spectrum.com; pgsql-admin


>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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
@ 2007-07-16 12:44     ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  2007-07-16 12:49       ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2 siblings, 1 reply; 22+ messages in thread

From: Ashish Karalkar @ 2007-07-16 12:44 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; Jayakumar_Mukundaraju@satyam.com; pgsql-admin

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
> 




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 12:44     ` Re: PgAgent Job Scheduling-Backup Ashish Karalkar <ashish.karalkar@info-spectrum.com>
@ 2007-07-16 12:49       ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 13:53         ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-16 12:49 UTC (permalink / raw)
  To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>; Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin

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

 

________________________________

From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
Sent: Mon 7/16/2007 6:14 PM
To: Vishal Arora; Jayakumar_Mukundaraju; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup



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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 12:44     ` Re: PgAgent Job Scheduling-Backup Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  2007-07-16 12:49       ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-16 13:53         ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-17 04:13           ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-16 13:53 UTC (permalink / raw)
  To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>; Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin

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"

 

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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 12:44     ` Re: PgAgent Job Scheduling-Backup Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  2007-07-16 12:49       ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 13:53         ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-17 04:13           ` Vishal Arora <aroravishal22@hotmail.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Vishal Arora @ 2007-07-17 04:13 UTC (permalink / raw)
  To: Jayakumar_Mukundaraju@satyam.com; ashish.karalkar@info-spectrum.com; pgsql-admin




>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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
@ 2007-07-17 05:01     ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-17 05:01 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

Dear Vishal,Ashish,
 
Good Morning... Today morning i seen three mails from your side.. all the mails are affected in spam virus... so I can't get that mails.. Kindly send mails again....
 
Thanks & Regards
Jayakumar M
 

________________________________

From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Mon 7/16/2007 6:11 PM
To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com; pgsql-admin@postgresql.org
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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
@ 2007-07-17 11:33     ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-17 13:16       ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-17 11:33 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

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) ????

      dbname=postgres (change if your maintenance database is different.)
      my Maintenance database is postgres. 
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.)
         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.???
6)      Start pgAgent service using the following command on command prompt    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 :- 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.

 
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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-17 11:33     ` PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-17 13:16       ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-17 13:30         ` Re: PgAgent Job Scheduling-Backup Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  0 siblings, 1 reply; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-17 13:16 UTC (permalink / raw)
  To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>; pgsql-admin; +Cc: Vishal Arora <aroravishal22@hotmail.com>

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 <mailto:Jayakumar_Mukundaraju@satyam.com>  
	To: Vishal Arora <mailto:aroravishal22@hotmail.com>  ; 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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
  2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-16 11:51 ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-16 12:41   ` Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
  2007-07-17 11:33     ` PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  2007-07-17 13:16       ` Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
@ 2007-07-17 13:30         ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Ashish Karalkar @ 2007-07-17 13:30 UTC (permalink / raw)
  To: Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>; pgsql-admin; +Cc: Vishal Arora <aroravishal22@hotmail.com>

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

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
@ 2007-07-16 10:18 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-16 10:18 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; ashish.karalkar@info-spectrum.com; pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
@ 2007-07-18 04:29 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-18 04:29 UTC (permalink / raw)
  To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin; +Cc: ashish.karalkar@info-spectrum.com

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@hotmail.com]
Sent: Tue 7/17/2007 9:47 PM
To: Jayakumar_Mukundaraju
Cc: ashish.karalkar@info-spectrum.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.karalkar@info-spectrum.com>
>To: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>,       
><pgsql-admin@postgresql.org>
>CC: "Vishal Arora" <aroravishal22@hotmail.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@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..

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

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: PgAgent Job Scheduling-Backup
@ 2007-07-19 11:37 Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
  0 siblings, 0 replies; 22+ messages in thread

From: Jayakumar_Mukundaraju @ 2007-07-19 11:37 UTC (permalink / raw)
  To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>; pgsql-admin; +Cc: aroravishal22@hotmail.com

Hello All,
 
One silly question ...  what are the difference between client  and server  postgres.
 
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.

^ permalink  raw  reply  [nested|flat] 22+ messages in thread


end of thread, other threads:[~2007-07-19 11:37 UTC | newest]

Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-11 05:23 PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-11 09:19 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-12 04:28 PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-13 04:44 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-16 06:34 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-13 05:56 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-13 07:16 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-16 07:02 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-16 07:08 Re: PgAgent Job Scheduling-Backup Vishal Arora <aroravishal22@hotmail.com>
2007-07-16 11:51 ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-16 12:41   ` Vishal Arora <aroravishal22@hotmail.com>
2007-07-16 12:44     ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
2007-07-16 12:49       ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-16 13:53         ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-17 04:13           ` Vishal Arora <aroravishal22@hotmail.com>
2007-07-17 05:01     ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-17 11:33     ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-17 13:16       ` Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-17 13:30         ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
2007-07-16 10:18 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-18 04:29 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>
2007-07-19 11:37 Re: PgAgent Job Scheduling-Backup Jayakumar_Mukundaraju <Jayakumar_Mukundaraju@satyam.com>

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