Обсуждение: PgAgent Job Scheduling-Backup

Поиск
Список
Период
Сортировка

PgAgent Job Scheduling-Backup

От
"Jayakumar_Mukundaraju"
Дата:
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/>
>> >
>> >
>> >
>> >
>> >
>> >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.
>
> _________________________________________________________________
> 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..

Re: PgAgent Job Scheduling-Backup

От
"Jayakumar_Mukundaraju"
Дата:
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/>
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >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.
>>
>>_________________________________________________________________
>>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..

Re: PgAgent Job Scheduling-Backup

От
"Jayakumar_Mukundaraju"
Дата:
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/>
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >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.
>>>>
>>>>_________________________________________________________________
>>>>Need a brain boost? Recharge with a stimulating game. Play now!
>>>>http://club.live.com/home.aspx?icid=club_hotmailtextlink1
>>>>
>>>
>>
>>_________________________________________________________________
>>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..

Re: PgAgent Job Scheduling-Backup

От
"Jayakumar_Mukundaraju"
Дата:
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/>
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >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.
>>>>
>>>>_________________________________________________________________
>>>>Need a brain boost? Recharge with a stimulating game. Play now!
>>>>http://club.live.com/home.aspx?icid=club_hotmailtextlink1
>>>>
>>>
>>
>>_________________________________________________________________
>>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..

PgAgent Job Scheduling-Backup

От
"Jayakumar_Mukundaraju"
Дата:
 
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..