Обсуждение: Re: Backup Scheduler...
From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Thu 7/26/2007 3:07 PM
To: Jayakumar_Mukundaraju
Cc: ashish.karalkar@info-spectrum.com
Subject: Re: [ADMIN] Backup Scheduler...
How are you calling this batch file and is pgAgent service running on your
system?
>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] Backup Scheduler...
>Date: Thu, 26 Jul 2007 12:13:59 +0530
>
>Dear Vishal/Ashish,
>
>Waiting for your reply....
>
>________________________________
>
>From: Jayakumar_Mukundaraju
>Sent: Thu 7/26/2007 9:45 AM
>To: Vishal Arora; ashish.karalkar@info-spectrum.com;
>pgsql-admin@postgresql.org
>Subject: RE: [ADMIN] Backup Scheduler...
>
>
>Dear Visha/Ashish,
>
>My batch file is content of below script.
>@echo off
>"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f
>D:\test\test1.sql -F p -C -d -D postgres
>@echo on
>
>I check the scheduler also.. That is also running ... Kindly give me the
>solution...
>
>Thanks & Regards
>Jayakumar M
>
>
>________________________________
>
>From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>Sent: Wed 7/25/2007 9:46 PM
>To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com;
>pgsql-admin@postgresql.org
>Subject: RE: [ADMIN] Backup Scheduler...
>
>
>
>Can you send your batch file pls. What is the time you are setting. Hope u
>r
>not doing the same thing as earlier.
>
>-- Vishal
>
>
> >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
> >To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>,
> ><pgsql-admin@postgresql.org>
> >Subject: [ADMIN] Backup Scheduler...
> >Date: Wed, 25 Jul 2007 18:12:40 +0530
> >
> >Dear Ashish/Vishal,
> >
> >How are u .. Here i am fine... I need a help from u ...
> >
> >In Windows, I have created new postgresql server & installed pgAgent
> >scheduler also..The pgAgent service is running, But when I try to
>schedule
> >the backup job, it is not running. The script seems to be ok since I
> >executed the .bat file manually, it is working.
> >
> >Can u please give me some solutions for this.
> >
> >Thanks & regards,
> > Jayakumar M
> >
> >________________________________
> >
> >From: pgsql-admin-owner@postgresql.org on behalf of Ashish Karalkar
> >Sent: Tue 7/24/2007 11:54 AM
> >To: pgsql-admin@postgresql.org
> >Subject: [ADMIN] Installing PgAdmin package on Linux
> >
> >
> >Hello All,
> >I am having PostgreSQL server 8.2.0 running on Redhat Linux .
> >I want to install PgAdmin GUI on the Linux Server.
> >can anybody please guide me to the appropriate documantation and the
> >prerequisite required for the same .
> >Thanks In Adavnce
> >
> >With Reagrds
> >Ashish...
> >
> >
> >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.
_________________________________________________________________
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..
Are you sure you have included "D:\test\test1.bat" within double quotes and selected the kind as batch in job. Can you see event log and send it to me, what is the exact error pgAgent service is giving. - 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] Backup Scheduler... >Date: Thu, 26 Jul 2007 15:34:59 +0530 > > >Dear Vishal/Ashish > >Yes i did same as u said... I created one job and i gave the schedule time >.30mnts and date also, and i create definition in step tab >D:\test\test1.bat.. > >If i given a command in command prompt C:\Program >Files\Postgresql\8.2\bin\ Net start pgAgent .. I get the result is the >service is already exist.. > >Give me the solution... > >Thanks & Regards >Jayakumar M > > > >________________________________ > >From: Vishal Arora [mailto:aroravishal22@hotmail.com] >Sent: Thu 7/26/2007 3:07 PM >To: Jayakumar_Mukundaraju >Cc: ashish.karalkar@info-spectrum.com >Subject: Re: [ADMIN] Backup Scheduler... > > > >How are you calling this batch file and is pgAgent service running on your >system? > > > >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] Backup Scheduler... > >Date: Thu, 26 Jul 2007 12:13:59 +0530 > > > >Dear Vishal/Ashish, > > > >Waiting for your reply.... > > > >________________________________ > > > >From: Jayakumar_Mukundaraju > >Sent: Thu 7/26/2007 9:45 AM > >To: Vishal Arora; ashish.karalkar@info-spectrum.com; > >pgsql-admin@postgresql.org > >Subject: RE: [ADMIN] Backup Scheduler... > > > > > >Dear Visha/Ashish, > > > >My batch file is content of below script. > >@echo off > >"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f > >D:\test\test1.sql -F p -C -d -D postgres > >@echo on > > > >I check the scheduler also.. That is also running ... Kindly give me the > >solution... > > > >Thanks & Regards > >Jayakumar M > > > > > >________________________________ > > > >From: Vishal Arora [mailto:aroravishal22@hotmail.com] > >Sent: Wed 7/25/2007 9:46 PM > >To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com; > >pgsql-admin@postgresql.org > >Subject: RE: [ADMIN] Backup Scheduler... > > > > > > > >Can you send your batch file pls. What is the time you are setting. Hope >u > >r > >not doing the same thing as earlier. > > > >-- Vishal > > > > > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > > >To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>, > > ><pgsql-admin@postgresql.org> > > >Subject: [ADMIN] Backup Scheduler... > > >Date: Wed, 25 Jul 2007 18:12:40 +0530 > > > > > >Dear Ashish/Vishal, > > > > > >How are u .. Here i am fine... I need a help from u ... > > > > > >In Windows, I have created new postgresql server & installed pgAgent > > >scheduler also..The pgAgent service is running, But when I try to > >schedule > > >the backup job, it is not running. The script seems to be ok since I > > >executed the .bat file manually, it is working. > > > > > >Can u please give me some solutions for this. > > > > > >Thanks & regards, > > > Jayakumar M > > > > > >________________________________ > > > > > >From: pgsql-admin-owner@postgresql.org on behalf of Ashish Karalkar > > >Sent: Tue 7/24/2007 11:54 AM > > >To: pgsql-admin@postgresql.org > > >Subject: [ADMIN] Installing PgAdmin package on Linux > > > > > > > > >Hello All, > > >I am having PostgreSQL server 8.2.0 running on Redhat Linux . > > >I want to install PgAdmin GUI on the Linux Server. > > >can anybody please guide me to the appropriate documantation and the > > >prerequisite required for the same . > > >Thanks In Adavnce > > > > > >With Reagrds > > >Ashish... > > > > > > > > >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/> ><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. > >_________________________________________________________________ >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. _________________________________________________________________ http://newlivehotmail.com
From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Thu 7/26/2007 4:32 PM
To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup Scheduler...
Are you sure you have included "D:\test\test1.bat" within double quotes and
selected the kind as batch in job.
Can you see event log and send it to me, what is the exact error pgAgent
service is giving.
- 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] Backup Scheduler...
>Date: Thu, 26 Jul 2007 15:34:59 +0530
>
>
>Dear Vishal/Ashish
>
>Yes i did same as u said... I created one job and i gave the schedule time
>.30mnts and date also, and i create definition in step tab
>D:\test\test1.bat..
>
>If i given a command in command prompt C:\Program
>Files\Postgresql\8.2\bin\ Net start pgAgent .. I get the result is the
>service is already exist..
>
>Give me the solution...
>
>Thanks & Regards
>Jayakumar M
>
>
>
>________________________________
>
>From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>Sent: Thu 7/26/2007 3:07 PM
>To: Jayakumar_Mukundaraju
>Cc: ashish.karalkar@info-spectrum.com
>Subject: Re: [ADMIN] Backup Scheduler...
>
>
>
>How are you calling this batch file and is pgAgent service running on your
>system?
>
>
> >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] Backup Scheduler...
> >Date: Thu, 26 Jul 2007 12:13:59 +0530
> >
> >Dear Vishal/Ashish,
> >
> >Waiting for your reply....
> >
> >________________________________
> >
> >From: Jayakumar_Mukundaraju
> >Sent: Thu 7/26/2007 9:45 AM
> >To: Vishal Arora; ashish.karalkar@info-spectrum.com;
> >pgsql-admin@postgresql.org
> >Subject: RE: [ADMIN] Backup Scheduler...
> >
> >
> >Dear Visha/Ashish,
> >
> >My batch file is content of below script.
> >@echo off
> >"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f
> >D:\test\test1.sql -F p -C -d -D postgres
> >@echo on
> >
> >I check the scheduler also.. That is also running ... Kindly give me the
> >solution...
> >
> >Thanks & Regards
> >Jayakumar M
> >
> >
> >________________________________
> >
> >From: Vishal Arora [mailto:aroravishal22@hotmail.com]
> >Sent: Wed 7/25/2007 9:46 PM
> >To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com;
> >pgsql-admin@postgresql.org
> >Subject: RE: [ADMIN] Backup Scheduler...
> >
> >
> >
> >Can you send your batch file pls. What is the time you are setting. Hope
>u
> >r
> >not doing the same thing as earlier.
> >
> >-- Vishal
> >
> >
> > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
> > >To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>,
> > ><pgsql-admin@postgresql.org>
> > >Subject: [ADMIN] Backup Scheduler...
> > >Date: Wed, 25 Jul 2007 18:12:40 +0530
> > >
> > >Dear Ashish/Vishal,
> > >
> > >How are u .. Here i am fine... I need a help from u ...
> > >
> > >In Windows, I have created new postgresql server & installed pgAgent
> > >scheduler also..The pgAgent service is running, But when I try to
> >schedule
> > >the backup job, it is not running. The script seems to be ok since I
> > >executed the .bat file manually, it is working.
> > >
> > >Can u please give me some solutions for this.
> > >
> > >Thanks & regards,
> > > Jayakumar M
> > >
> > >________________________________
> > >
> > >From: pgsql-admin-owner@postgresql.org on behalf of Ashish Karalkar
> > >Sent: Tue 7/24/2007 11:54 AM
> > >To: pgsql-admin@postgresql.org
> > >Subject: [ADMIN] Installing PgAdmin package on Linux
> > >
> > >
> > >Hello All,
> > >I am having PostgreSQL server 8.2.0 running on Redhat Linux .
> > >I want to install PgAdmin GUI on the Linux Server.
> > >can anybody please guide me to the appropriate documantation and the
> > >prerequisite required for the same .
> > >Thanks In Adavnce
> > >
> > >With Reagrds
> > >Ashish...
> > >
> > >
> > >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/>
><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.
>
>_________________________________________________________________
>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.
_________________________________________________________________
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..
From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Thu 7/26/2007 4:32 PM
To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup Scheduler...
Are you sure you have included "D:\test\test1.bat" within double quotes and
selected the kind as batch in job.
Can you see event log and send it to me, what is the exact error pgAgent
service is giving.
- 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] Backup Scheduler...
>Date: Thu, 26 Jul 2007 15:34:59 +0530
>
>
>Dear Vishal/Ashish
>
>Yes i did same as u said... I created one job and i gave the schedule time
>.30mnts and date also, and i create definition in step tab
>D:\test\test1.bat..
>
>If i given a command in command prompt C:\Program
>Files\Postgresql\8.2\bin\ Net start pgAgent .. I get the result is the
>service is already exist..
>
>Give me the solution...
>
>Thanks & Regards
>Jayakumar M
>
>
>
>________________________________
>
>From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>Sent: Thu 7/26/2007 3:07 PM
>To: Jayakumar_Mukundaraju
>Cc: ashish.karalkar@info-spectrum.com
>Subject: Re: [ADMIN] Backup Scheduler...
>
>
>
>How are you calling this batch file and is pgAgent service running on your
>system?
>
>
> >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] Backup Scheduler...
> >Date: Thu, 26 Jul 2007 12:13:59 +0530
> >
> >Dear Vishal/Ashish,
> >
> >Waiting for your reply....
> >
> >________________________________
> >
> >From: Jayakumar_Mukundaraju
> >Sent: Thu 7/26/2007 9:45 AM
> >To: Vishal Arora; ashish.karalkar@info-spectrum.com;
> >pgsql-admin@postgresql.org
> >Subject: RE: [ADMIN] Backup Scheduler...
> >
> >
> >Dear Visha/Ashish,
> >
> >My batch file is content of below script.
> >@echo off
> >"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f
> >D:\test\test1.sql -F p -C -d -D postgres
> >@echo on
> >
> >I check the scheduler also.. That is also running ... Kindly give me the
> >solution...
> >
> >Thanks & Regards
> >Jayakumar M
> >
> >
> >________________________________
> >
> >From: Vishal Arora [mailto:aroravishal22@hotmail.com]
> >Sent: Wed 7/25/2007 9:46 PM
> >To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com;
> >pgsql-admin@postgresql.org
> >Subject: RE: [ADMIN] Backup Scheduler...
> >
> >
> >
> >Can you send your batch file pls. What is the time you are setting. Hope
>u
> >r
> >not doing the same thing as earlier.
> >
> >-- Vishal
> >
> >
> > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
> > >To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>,
> > ><pgsql-admin@postgresql.org>
> > >Subject: [ADMIN] Backup Scheduler...
> > >Date: Wed, 25 Jul 2007 18:12:40 +0530
> > >
> > >Dear Ashish/Vishal,
> > >
> > >How are u .. Here i am fine... I need a help from u ...
> > >
> > >In Windows, I have created new postgresql server & installed pgAgent
> > >scheduler also..The pgAgent service is running, But when I try to
> >schedule
> > >the backup job, it is not running. The script seems to be ok since I
> > >executed the .bat file manually, it is working.
> > >
> > >Can u please give me some solutions for this.
> > >
> > >Thanks & regards,
> > > Jayakumar M
> > >
> > >________________________________
> > >
> > >From: pgsql-admin-owner@postgresql.org on behalf of Ashish Karalkar
> > >Sent: Tue 7/24/2007 11:54 AM
> > >To: pgsql-admin@postgresql.org
> > >Subject: [ADMIN] Installing PgAdmin package on Linux
> > >
> > >
> > >Hello All,
> > >I am having PostgreSQL server 8.2.0 running on Redhat Linux .
> > >I want to install PgAdmin GUI on the Linux Server.
> > >can anybody please guide me to the appropriate documantation and the
> > >prerequisite required for the same .
> > >Thanks In Adavnce
> > >
> > >With Reagrds
> > >Ashish...
> > >
> > >
> > >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/>
><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.
>
>_________________________________________________________________
>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.
_________________________________________________________________
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..
From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Fri 7/27/2007 12:59 PM
To: Jayakumar_Mukundaraju
Subject: RE: [ADMIN] Backup Scheduler...
Subject: Re: [ADMIN] Backup Scheduler...
Date: Fri, 27 Jul 2007 12:03:36 +0530
From: Jayakumar_Mukundaraju@satyam.com
To: aroravishal22@hotmail.com; ashish.karalkar@info-spectrum.com; pgsql-admin@postgresql.orgDear Vishal/Ashish,Is there any related in Task Scheduler in my system.. The task scheduler is stopped in my system..Are you talking about pgAgent Service that is running or something else. You do not have to use the Windows task scheduler for running the Postgres jobs once you have installed pgAgent in pgAdmin III.Thanks & RegardsJayakumar M
From: Vishal Arora [mailto:aroravishal22@hotmail.com]
Sent: Thu 7/26/2007 4:32 PM
To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup Scheduler...Are you sure you have included "D:\test\test1.bat" within double quotes and
selected the kind as batch in job.
Can you see event log and send it to me, what is the exact error pgAgent
service is giving.
- 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] Backup Scheduler...
>Date: Thu, 26 Jul 2007 15:34:59 +0530
>
>
>Dear Vishal/Ashish
>
>Yes i did same as u said... I created one job and i gave the schedule time
>.30mnts and date also, and i create definition in step tab
>D:\test\test1.bat..
>
>If i given a command in command prompt C:\Program
>Files\Postgresql\8.2\bin\ Net start pgAgent .. I get the result is the
>service is already exist..
>
>Give me the solution...
>
>Thanks & Regards
>Jayakumar M
>
>
>
>________________________________
>
>From: Vishal Arora [mailto:aroravishal22@hotmail.com]
>Sent: Thu 7/26/2007 3:07 PM
>To: Jayakumar_Mukundaraju
>Cc: ashish.karalkar@info-spectrum.com
>Subject: Re: [ADMIN] Backup Scheduler...
>
>
>
>How are you calling this batch file and is pgAgent service running on your
>system?
>
>
> >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] Backup Scheduler...
> >Date: Thu, 26 Jul 2007 12:13:59 +0530
> >
> >Dear Vishal/Ashish,
> >
> >Waiting for your reply....
> >
> >________________________________
> >
> >From: Jayakumar_Mukundaraju
> >Sent: Thu 7/26/2007 9:45 AM
> >To: Vishal Arora; ashish.karalkar@info-spectrum.com;
> >pgsql-admin@postgresql.org
> >Subject: RE: [ADMIN] Backup Scheduler...
> >
> >
> >Dear Visha/Ashish,
> >
> >My batch file is content of below script.
> >@echo off
> >"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f
> >D:\test\test1.sql -F p -C -d -D postgres
> >@echo on
> >
> >I check the scheduler also.. That is also running ... Kindly give me the
> >solution...
> >
> >Thanks & Regards
> >Jayakumar M
> >
> >
> >________________________________
> >
> >From: Vishal Arora [mailto:aroravishal22@hotmail.com]
> >Sent: Wed 7/25/2007 9:46 PM
> >To: Jayakumar_Mukundaraju; ashish.karalkar@info-spectrum.com;
> >pgsql-admin@postgresql.org
> >Subject: RE: [ADMIN] Backup Scheduler...
> >
> >
> >
> >Can you send your batch file pls. What is the time you are setting. Hope
>u
> >r
> >not doing the same thing as earlier.
> >
> >-- Vishal
> >
> >
> > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com>
> > >To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>,
> > ><pgsql-admin@postgresql.org>
> > >Subject: [ADMIN] Backup Scheduler...
> > >Date: Wed, 25 Jul 2007 18:12:40 +0530
> > >
> > >Dear Ashish/Vishal,
> > >
> > >How are u .. Here i am fine... I need a help from u ...
> > >
> > >In Windows, I have created new postgresql server & installed pgAgent
> > >scheduler also..The pgAgent service is running, But when I try to
> >schedule
> > >the backup job, it is not running. The script seems to be ok since I
> > >executed the .bat file manually, it is working.
> > >
> > >Can u please give me some solutions for this.
> > >
> > >Thanks & regards,
> > > Jayakumar M
> > >
> > >________________________________
> > >
> > >From: pgsql-admin-owner@postgresql.org on behalf of Ashish Karalkar
> > >Sent: Tue 7/24/2007 11:54 AM
> > >To: pgsql-admin@postgresql.org
> > >Subject: [ADMIN] Installing PgAdmin package on Linux
> > >
> > >
> > >Hello All,
> > >I am having PostgreSQL server 8.2.0 running on Redhat Linux .
> > >I want to install PgAdmin GUI on the Linux Server.
> > >can anybody please guide me to the appropriate documantation and the
> > >prerequisite required for the same .
> > >Thanks In Adavnce
> > >
> > >With Reagrds
> > >Ashish...
> > >
> > >
> > >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/>
><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.
>
>_________________________________________________________________
>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.
_________________________________________________________________
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..
PC Magazine’s 2007 editors’ choice for best web mail—award-winning Windows Live Hotmail. Check it out!
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..
@echo off
rem "C:\Program Files\PostgreSQL\8.2\bin\pg_dump" -U (user name) -F c -f "postgres_db.bak" -F p -C -D (database name)
@echno on
REM author :jaikumar@.gmail.com,
REM Dont hasitate to a suggestions
Set CURRTIME=CURRTIME.TMP
TIME /T > %CURRTIME%
For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=%%l%%k%%j
For /F %PARSEARG% %%i in (%CURRTIME%) Do Set HHMM=%%i%%j%%k
ren "D:\BACKUP\postgres_db.backup" "postgres_db_%YYYYMMDD%_%HHMM%.backup"
del currdate.tmp
del currtime.tmp
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..