Обсуждение: Re: Backup Scheduler...

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

Re: Backup Scheduler...

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

Re: Backup Scheduler...

От
"Vishal Arora"
Дата:
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


Re: Backup Scheduler...

От
"Jayakumar_Mukundaraju"
Дата:
I didn't seen any error in event log... I set the schedule in 4.40pm today.. In 4.41 in my system the cursor action is changed to some
process is going..
 
Thanks & Regards
Jayakumar 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..

Re: Backup Scheduler...

От
"Jayakumar_Mukundaraju"
Дата:
Dear Vishal/Ashish,
 
Is there any related in Task Scheduler in my system.. The task scheduler is stopped in my system..
 
Thanks & Regards
Jayakumar 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..

Re: Backup Scheduler...

От
"Jayakumar_Mukundaraju"
Дата:
I checked in control pannel>>Administrative tool>>services... the postgreSQL Scheduling Agent service is running...
 
I didn't understand how my job is not running... Give me the solution ....
 
Jayakumar M
 


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

Dear 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 & Regards
Jayakumar 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..

Reg : Backup job Scheduler...

От
"Jayakumar_Mukundaraju"
Дата:
Dear All,
 
I did the Backup job schedule in windows through Schedule Task, it is working fine..
 
The following are the steps..
 
1. I created one batch file in my D:\Backup\postgres_backup.bat
      The contents are..
          
@echo off
rem "c:\Program Files\pgAdmin III\1.7\pg_dump.exe" -i -h localhost -p 5432 -U rajbackup -F t -b -f "postgres_db.tar" raj

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)
"C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p 5432 -U postgress -F c -v -f "D:\BACKUP\postgres_db.backup" Database name
rem "C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p 5432 -U postgress -F p -v -f "D:\BACKUP\raj\postgres_db.sql" Database name

@echno on
 
2. After i created one more  batchfile backup_post.bat
     The contents are
 
@echo off
REM author :jaikumar@.gmail.com,
REM Dont hasitate to a suggestions
call postgres_backup.bat
Set CURRDATE=CURRDATE.TMP
Set CURRTIME=CURRTIME.TMP
DATE /T > %CURRDATE%
TIME /T > %CURRTIME%
Set PARSEARG="eol=; tokens=1,2,3,4* delims=/, "
For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=%%l%%k%%j
Set PARSEARG="eol=; tokens=1,2,3* delims=:, "
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
3. I scheduled the jobs in schedule task, that is in control pannel,
  a.  Task : -  Create new job name...
                   start in : D:\BACKUP\
                  RUN as : your login name
              put a tick mark in Enabled [scheduled task runs at specified time]
 
 b. Schedule..
     schedule task: Daily     start time : 12.00 am .... and go to Advance
        tick    Repeat task   ... Every column give (Hours u want) (mintues and hours)
        Duration   24...... give OK 
 
C. Settings  :     tick    Wake the computer to run this task..
 
d. Security  : check the login permissions..   and clik ok ... check the backup job stored place..
 
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..