Installing PgAdmin package on Linux

Installing PgAdmin package on Linux

am 24.07.2007 08:24:33 von Ashish Karalkar

This is a multi-part message in MIME format.

------=_NextPart_000_0080_01C7CDE9.66825500
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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...
------=_NextPart_000_0080_01C7CDE9.66825500
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">





Hello All,

I am having PostgreSQL server 8.2.0 =
running on=20
Redhat Linux .

I want to install PgAdmin GUI on the =
Linux=20
Server.

can anybody please guide me to the =
appropriate=20
documantation and the prerequisite required for the same .

Thanks In Adavnce

 

With Reagrds

size=3D2>Ashish...


------=_NextPart_000_0080_01C7CDE9.66825500--

Re: Installing PgAdmin package on Linux

am 25.07.2007 06:11:20 von Vishal Arora

HI Ashish,

Try to download the source for Linux installation from the PgAdmin site.
untar and try to complile using ./configure make and make install steps.
Just test what happens. I too do not see any options give somewhere. you can
also go through Readme file give with the source binary. I am not on linux
system these days or else I could have tried and told you.

- Vishal


>From: "Ashish Karalkar"
>To:
>Subject: [ADMIN] Installing PgAdmin package on Linux
>Date: Tue, 24 Jul 2007 11:54:33 +0530
>
>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...

____________________________________________________________ _____
Don't get caught with egg on your face. Play Chicktionary! 
http://club.live.com/chicktionary.aspx?icid=chick_hotmailtex tlink2


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Using Explain

am 25.07.2007 11:00:57 von Vishal Arora

Hi All,

I was looking for extensive tutorial for Explain, Plan-reading. The postgres
manual is not exhaustive enough.

It would be great if somone has a link to some documentation which gives
some more in depth information about EXPLAIN / Plan Reading

Thanks

Vishal

____________________________________________________________ _____
Don't get caught with egg on your face. Play Chicktionary! 
http://club.live.com/chicktionary.aspx?icid=chick_hotmailtex tlink2


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Using Explain

am 25.07.2007 13:26:57 von milen

Vishal Arora написа:
>=20
> Hi All,
>=20
> I was looking for extensive tutorial for Explain, Plan-reading. The
> postgres manual is not exhaustive enough.
>=20
> It would be great if somone has a link to some documentation which give=
s
> some more in depth information about EXPLAIN / Plan Reading
>=20

http://www.postgresql.org/communityfiles/13.sxi



--=20
Milen A. Radev


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Using Explain

am 25.07.2007 14:38:31 von Vishal Arora

>From: "Milen A. Radev"
>To: pgsql-admin@postgresql.org
>Subject: Re: [ADMIN] Using Explain
>Date: Wed, 25 Jul 2007 14:26:57 +0300
>
>Vishal Arora написа:
> >
> > Hi All,
> >
> > I was looking for extensive tutorial for Explain, Plan-reading. The
> > postgres manual is not exhaustive enough.
> >
> > It would be great if somone has a link to some documentation which gives
> > some more in depth information about EXPLAIN / Plan Reading
> >
>
>http://www.postgresql.org/communityfiles/13.sxi

Thanks for the link. I am sorry but I am not able to view this file.
>
>

>
>--
>Milen A. Radev
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings

____________________________________________________________ _____
Don't get caught with egg on your face. Play Chicktionary! 
http://club.live.com/chicktionary.aspx?icid=chick_hotmailtex tlink2


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Backup Scheduler...

am 25.07.2007 14:42:40 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7CEB9.49B1E137
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Ashish/Vishal,
=20
How are u .. Here i am fine... I need a help from u ...=20
=20
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.=20
=20
Can u please give me some solutions for this.=20
=20
Thanks & regards,=20
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
=20
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.

------_=_NextPart_001_01C7CEB9.49B1E137
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=0A=
=0A=
=0A=
=0A=
=0A=
=0A=

=0A=
Dear =
Ashish/Vishal,
=0A=
 
=0A=
How are u .. Here i am =
fine... I need a help from u ...
=0A=
 
=0A=
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.
=0A=
 
=0A=
Can u please give me some =
solutions for this.
=0A=
 
=0A=
Thanks & regards, =
=0A=
 Jayakumar M
=0A=

=0A=

=0A=
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

=0A=
=0A=
=0A=
Hello All,
=0A=
I am having PostgreSQL server 8.2.0 =
running on Redhat Linux .
=0A=
I want to install PgAdmin GUI on the =
Linux Server.
=0A=
can anybody please guide me to the =
appropriate documantation and the prerequisite required for the same =
..
=0A=
Thanks In Adavnce
=0A=
 
=0A=
With Reagrds
=0A=
size=3D2>Ashish...

DISCLAIMER: r>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..
------_=_NextPart_001_01C7CEB9.49B1E137--

Re: Backup Scheduler...

am 25.07.2007 18:16:52 von Vishal Arora

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"
>To: "Ashish Karalkar" ,
>
>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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Using Explain

am 25.07.2007 22:53:25 von Steve Holdoway

On Wed, 25 Jul 2007 12:38:31 +0000
"Vishal Arora" wrote:

>=20
>=20
>=20
> >From: "Milen A. Radev"
> >To: pgsql-admin@postgresql.org
> >Subject: Re: [ADMIN] Using Explain
> >Date: Wed, 25 Jul 2007 14:26:57 +0300
> >
> >Vishal Arora написа:
> > >
> > > Hi All,
> > >
> > > I was looking for extensive tutorial for Explain, Plan-reading. The
> > > postgres manual is not exhaustive enough.
> > >
> > > It would be great if somone has a link to some documentation which gi=
ves
> > > some more in depth information about EXPLAIN / Plan Reading
> > >
> >
> >http://www.postgresql.org/communityfiles/13.sxi
>=20
> Thanks for the link. I am sorry but I am not able to view this file.
> >
> >
Try saving it and open with OpenOffice...

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: Backup Scheduler...

am 26.07.2007 06:15:01 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7CF3B.CABF243C
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Visha/Ashish,
=20
My batch file is content of below script.
@echo off=20
"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f =
D:\test\test1.sql -F p -C -d -D postgres=20
@echo on
=20
I check the scheduler also.. That is also running ... Kindly give me the =
solution...
=20
Thanks & Regards
Jayakumar M

=20
________________________________

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"
>To: "Ashish Karalkar" , =20
>
>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 =20






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.

------_=_NextPart_001_01C7CF3B.CABF243C
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

RE: [ADMIN] Backup Scheduler...=0A=
=0A=
=0A=
=0A=

=0A=
Dear =
Visha/Ashish,
=0A=
 
=0A=
My batch file is content of =
below script.
=0A=
@echo off
"C:\Program =
FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f  D:\test\test1.sql =
-F p -C -d -D postgres
=0A=
@echo on
=0A=
 
=0A=
I check the scheduler also.. That is also running ... =
Kindly give me the solution...
=0A=
 
=0A=
Thanks & Regards
=0A=
Jayakumar M
=0A=

 
=0A=
=0A=

=0A=
=0A=
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...

=0A=
=0A=

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>,     &=
nbsp; 
><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.

_____________________________________________________=
____________
href=3D"http://newlivehotmail.com/">http://newlivehotmail.co 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..
------_=_NextPart_001_01C7CF3B.CABF243C--

Re: Backup Scheduler...

am 26.07.2007 08:43:59 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7CF50.6D3E98D1
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Vishal/Ashish,
=20
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,
=20
My batch file is content of below script.
@echo off=20
"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f =
D:\test\test1.sql -F p -C -d -D postgres=20
@echo on
=20
I check the scheduler also.. That is also running ... Kindly give me the =
solution...
=20
Thanks & Regards
Jayakumar M

=20
________________________________

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"
>To: "Ashish Karalkar" , =20
>
>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 =20






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.

------_=_NextPart_001_01C7CF50.6D3E98D1
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

RE: [ADMIN] Backup Scheduler...=0A=
=0A=
=0A=
=0A=

=0A=
Dear =
Vishal/Ashish,
=0A=
 
=0A=
Waiting for your =
reply....
=0A=

=0A=

=0A=
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...

=0A=
=0A=
=0A=
Dear =
Visha/Ashish,
=0A=
 
=0A=
My batch file is content of =
below script.
=0A=
@echo off
"C:\Program =
FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f  D:\test\test1.sql =
-F p -C -d -D postgres
=0A=
@echo on
=0A=
 
=0A=
I check the scheduler also.. That is also running ... =
Kindly give me the solution...
=0A=
 
=0A=
Thanks & Regards
=0A=
Jayakumar M
=0A=

 
=0A=
=0A=

=0A=
=0A=
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...

=0A=
=0A=

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>,     &=
nbsp; 
><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.

_____________________________________________________=
____________
href=3D"http://newlivehotmail.com/">http://newlivehotmail.co 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..
------_=_NextPart_001_01C7CF50.6D3E98D1--

Re: Backup Scheduler...

am 26.07.2007 12:04:59 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7CF6C.83899562
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=20
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..
=20
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..
=20
Give me the solution...
=20
Thanks & Regards
Jayakumar M
=20
=20

________________________________

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"
>To: "Vishal Arora" , =20
>,
>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=20
>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"
> >To: "Ashish Karalkar" ,
> >
> >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 =

>
>
>
>
>
>
>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 =20






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.

------_=_NextPart_001_01C7CF6C.83899562
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Re: [ADMIN] Backup Scheduler...=0A=
=0A=
=0A=
=0A=

=0A=
size=3D2> 
=0A=
Dear Vishal/Ashish
=0A=
=0A=
=0A=
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..
=0A=
 
=0A=
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..
=0A=
 
=0A=
Give me the =
solution...
=0A=
 
=0A=
Thanks & =
Regards
=0A=
Jayakumar M
=0A=
 
=0A=
 
=0A=

=0A=

=0A=
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...

=0A=
=0A=

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>,      &nb=
sp;
><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
&=
gt;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 [ href=3D"mailto:aroravishal22@hotmail.com">mailto:aroravishal 22@hotmail.co=
m
]
>Sent: Wed 7/25/2007 9:46 PM
>To: =
Jayakumar_Mukundaraju; =
ashish.karalkar@info-spectrum.com;
>pgsql-admin@postgresql.org
&=
gt;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.
>
>_____________________________________________=
____________________
> href=3D"http://newlivehotmail.com/">http://newlivehotmail.co m < href=3D"http://newlivehotmail.com/">http://newlivehotmail.co m/> >>
>
>
>
>
>
>DISCLAIMER:
>T=
his 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.

_____________________________________________________=
____________
href=3D"http://liveearth.msn.com/">http://liveearth.msn.com

R>

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..
------_=_NextPart_001_01C7CF6C.83899562--

Re: Backup Scheduler...

am 26.07.2007 13:02:23 von 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"
>To: "Jayakumar_Mukundaraju" ,
>"Vishal Arora" ,
>,
>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"
> >To: "Vishal Arora" ,
> >,
> >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"
> > >To: "Ashish Karalkar" ,
> > >
> > >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
>
> >
> >
> >
> >
> >
> >
> >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.

____________________________________________________________ _____
http://newlivehotmail.com


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Backup Scheduler...

am 26.07.2007 13:16:07 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7CF77.0AD632FA
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=20
process is going..=20
=20
Thanks & Regards
Jayakumar M
=20

________________________________

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"
>To: "Jayakumar_Mukundaraju" , =20
>"Vishal Arora" , =20
>,
>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"
> >To: "Vishal Arora" ,
> >,
> >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"
> > >To: "Ashish Karalkar" ,
> > >
> > >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 =
=20
>
> >
> >
> >
> >
> >
> >
> >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.

____________________________________________________________ _____
http://newlivehotmail.com =20






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.

------_=_NextPart_001_01C7CF77.0AD632FA
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Re: [ADMIN] Backup Scheduler...=0A=
=0A=
=0A=
=0A=

=0A=
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
=0A=
process is =
going..
=0A=
 
=0A=
Thanks & =
Regards
=0A=
Jayakumar M
=0A=
 
=0A=

=0A=

=0A=
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...

=0A=
=0A=

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>,     &n=
bsp; 
>"Vishal Arora" =
<aroravishal22@hotmail.com>,      &nb=
sp;
><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 [ href=3D"mailto:aroravishal22@hotmail.com">mailto:aroravishal 22@hotmail.co=
m
]
>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 [ href=3D"mailto:aroravishal22@hotmail.com">mailto:aroravishal 22@hotmail.co=
m
]
> >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.
> >
> =
> ____________________________________________________________ _____
=
> > href=3D"http://newlivehotmail.com/">http://newlivehotmail.co m < href=3D"http://newlivehotmail.com/">http://newlivehotmail.co m/>&nb=
sp;
>< href=3D"http://newlivehotmail.com/">http://newlivehotmail.co 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.
>
>_____________________________________________=
____________________
> href=3D"http://liveearth.msn.com/">http://liveearth.msn.com < href=3D"http://liveearth.msn.com/">http://liveearth.msn.com/>
&=
gt;
>
>
>
>
>
>DISCLAIMER:
>Thi=
s 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.

_____________________________________________________=
____________
href=3D"http://newlivehotmail.com/">http://newlivehotmail.co 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..
------_=_NextPart_001_01C7CF77.0AD632FA--

Re: Backup Scheduler...

am 26.07.2007 16:00:02 von Richard Broersma Jr

--- Jayakumar_Mukundaraju wrote:

> Dear Visha/Ashish,
> =20
> My batch file is content of below script.
> @echo off=20
> "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f D:\test\t=
est1.sql -F p -C -d -D
> postgres=20
> @echo on
> =20

The solution that I use is found on this link:
http://archives.postgresql.org/pgsql-general/2006-12/msg0148 6.php

Maybe be it can give you some ideas that you can use in your bat script f=
ile.
Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Backup Scheduler...

am 27.07.2007 08:33:36 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7D018.42449F1B
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Vishal/Ashish,
=20
Is there any related in Task Scheduler in my system.. The task scheduler =
is stopped in my system..
=20
Thanks & Regards
Jayakumar M
=20

________________________________

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"
>To: "Jayakumar_Mukundaraju" , =20
>"Vishal Arora" , =20
>,
>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"
> >To: "Vishal Arora" ,
> >,
> >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"
> > >To: "Ashish Karalkar" ,
> > >
> > >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 =
=20
>
> >
> >
> >
> >
> >
> >
> >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.

____________________________________________________________ _____
http://newlivehotmail.com =20






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.

------_=_NextPart_001_01C7D018.42449F1B
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Re: [ADMIN] Backup Scheduler...=0A=
=0A=
=0A=
=0A=

=0A=
Dear =
Vishal/Ashish,
=0A=
 
=0A=
Is there any related in Task =
Scheduler in my system.. The task scheduler is stopped in my =
system..
=0A=
 
=0A=
Thanks & =
Regards
=0A=
Jayakumar M
=0A=
 
=0A=

=0A=

=0A=
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...

=0A=
=0A=

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>,     &n=
bsp; 
>"Vishal Arora" =
<aroravishal22@hotmail.com>,      &nb=
sp;
><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 [ href=3D"mailto:aroravishal22@hotmail.com">mailto:aroravishal 22@hotmail.co=
m
]
>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 [ href=3D"mailto:aroravishal22@hotmail.com">mailto:aroravishal 22@hotmail.co=
m
]
> >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.
> >
> =
> ____________________________________________________________ _____
=
> > href=3D"http://newlivehotmail.com/">http://newlivehotmail.co m < href=3D"http://newlivehotmail.com/">http://newlivehotmail.co m/>&nb=
sp;
>< href=3D"http://newlivehotmail.com/">http://newlivehotmail.co 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.
>
>_____________________________________________=
____________________
> href=3D"http://liveearth.msn.com/">http://liveearth.msn.com < href=3D"http://liveearth.msn.com/">http://liveearth.msn.com/>
&=
gt;
>
>
>
>
>
>DISCLAIMER:
>Thi=
s 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.

_____________________________________________________=
____________
href=3D"http://newlivehotmail.com/">http://newlivehotmail.co 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..
------_=_NextPart_001_01C7D018.42449F1B--

Re: Backup Scheduler...

am 27.07.2007 09:40:41 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7D021.6EFCD3EA
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I checked in control pannel>>Administrative tool>>services... the =
postgreSQL Scheduling Agent service is running...
=20
I didn't understand how my job is not running... Give me the solution =
.....
=20
Jayakumar M
=20

________________________________

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
=09
=09
Dear Vishal/Ashish,
=20
Is there any related in Task Scheduler in my system.. The task =
scheduler is stopped in my system..
=20
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.=20
=20
=20
Thanks & Regards
Jayakumar M
=20

________________________________

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...
=09
=09
Are you sure you have included "D:\test\test1.bat" within double quotes =
and
selected the kind as batch in job.
=09
Can you see event log and send it to me, what is the exact error =
pgAgent
service is giving.
=09
- Vishal
=09
=09
>From: "Jayakumar_Mukundaraju"
>To: "Jayakumar_Mukundaraju" , =20
>"Vishal Arora" , =20
>,
>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"
> >To: "Vishal Arora" ,
> >,
> >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"
> > >To: "Ashish Karalkar" ,
> > >
> > >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 =
=20
>
> >
> >
> >
> >
> >
> >
> >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.
=09
____________________________________________________________ _____
http://newlivehotmail.com =20
=09
=09
=09
=09

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..
=09


________________________________

PC Magazine's 2007 editors' choice for best web mail-award-winning =
Windows Live Hotmail. Check it out! =
migration_HMWL_mini_pcmag_0707> =20


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.

------_=_NextPart_001_01C7D021.6EFCD3EA
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=0A=
=0A=
=0A=
=0A=
=0A=
=0A=

=0A=
I checked in =
control pannel>>Administrative tool>>services... the =
postgreSQL Scheduling Agent service is running...
=0A=
 
=0A=
I didn't understand how my job is not =
running... Give me the solution ....
=0A=
 
=0A=
Jayakumar M
=0A=
 
=0A=

=0A=

=0A=
From: Vishal Arora =
[mailto:aroravishal22@hotmail.com]
Sent: Fri 7/27/2007 12:59 =
PM
To: Jayakumar_Mukundaraju
Subject: RE: [ADMIN] =
Backup Scheduler...

=0A=


=0A=
=0A=

=0A=
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

=0A=
=0A=
Dear =
Vishal/Ashish,
=0A=
 
=0A=
Is there any related in Task =
Scheduler in my system.. The task scheduler is stopped in my =
system..
=0A=
 
=0A=
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.
=0A=
 
=0A=
 
=0A=
Thanks & =
Regards
=0A=
Jayakumar M
=0A=
 
=0A=

=0A=

=0A=
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...

=0A=
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>,     &n=
bsp; 
>"Vishal Arora" =
<aroravishal22@hotmail.com>,      &nb=
sp;
><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 [ href=3D"mailto:aroravishal22@hotmail.com">mailto:aroravishal 22@hotmail.co=
m
]
>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 [ href=3D"mailto:aroravishal22@hotmail.com">mailto:aroravishal 22@hotmail.co=
m
]
> >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.
> >
> =
> ____________________________________________________________ _____
=
> > target=3D_blank>http://newlivehotmail.com < href=3D"http://newlivehotmail.com/" =
target=3D_blank>http://newlivehotmail.com/

>< href=3D"http://newlivehotmail.com/" =
target=3D_blank>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.
>
>_____________________________________________=
____________________
> target=3D_blank>http://liveearth.msn.com < href=3D"http://liveearth.msn.com/" =
target=3D_blank>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.

_____________________________________________________=
____________
target=3D_blank>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..

=0A=

=0A=
PC Magazine’s 2007 editors’ choice for best web =
mail—award-winning Windows Live Hotmail. href=3D"http://imagine-windowslive.com/hotmail/?locale=3Den- us&ocid=3D=
TXT_TAGHM_migration_HMWL_mini_pcmag_0707" target=3D_new>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..
------_=_NextPart_001_01C7D021.6EFCD3EA--

Reg : Backup job Scheduler...

am 03.08.2007 13:22:40 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7D5C0.9A92C333
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear All,
=20
I did the Backup job schedule in windows through Schedule Task, it is =
working fine..
=20
The following are the steps..
=20
1. I created one batch file in my D:\Backup\postgres_backup.bat
The contents are..
=20
@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
=20
2. After i created one more batchfile backup_post.bat
The contents are=20
=20
@echo off
REM author :jaikumar@.gmail.com,
REM Dont hasitate to a suggestions=20
call postgres_backup.bat
Set CURRDATE=3DCURRDATE.TMP
Set CURRTIME=3DCURRTIME.TMP
DATE /T > %CURRDATE%
TIME /T > %CURRTIME%
Set PARSEARG=3D"eol=3D; tokens=3D1,2,3,4* delims=3D/, "
For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=3D%%l%%k%%j
Set PARSEARG=3D"eol=3D; tokens=3D1,2,3* delims=3D:, "
For /F %PARSEARG% %%i in (%CURRTIME%) Do Set HHMM=3D%%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]
=20
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 =20
=20
C. Settings : tick Wake the computer to run this task..
=20
d. Security : check the login permissions.. and clik ok ... check the =
backup job stored place..
=20
Thanks & Regards
Jayakumar M
=20
=20
=20
=20


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.

------_=_NextPart_001_01C7D5C0.9A92C333
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Re: [ADMIN] Backup Scheduler...=0A=
=0A=
=0A=
=0A=

=0A=
Dear =
All,
=0A=
 
=0A=
I did the Backup job schedule =
in windows through Schedule Task, it is working fine..
=0A=
 
=0A=
The following are the =
steps..
=0A=
 
=0A=
1. I created one batch file =
in my D:\Backup\postgres_backup.bat
=0A=
size=3D2>      The contents are..
=0A=
size=3D2>           =

@echo off
=0A=
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
=0A=

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)
=0A=
"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
=0A=
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
=0A=

@echno on
=0A=
 
=0A=
2. After i created one more =
 batchfile backup_post.bat
=0A=
     The =
contents are
=0A=
 
=0A=
@echo off
REM author :jaikumar@.gmail.com,
REM Dont =
hasitate to a suggestions
=0A=
call postgres_backup.bat
=0A=
Set CURRDATE=3DCURRDATE.TMP
Set =
CURRTIME=3DCURRTIME.TMP
=0A=
DATE /T > %CURRDATE%
TIME /T > %CURRTIME%
=0A=
Set PARSEARG=3D"eol=3D; tokens=3D1,2,3,4* delims=3D/, =
"
For /F %PARSEARG% %%i in (%CURRDATE%) Do SET =
YYYYMMDD=3D%%l%%k%%j
=0A=
Set PARSEARG=3D"eol=3D; tokens=3D1,2,3* delims=3D:, =
"
For /F %PARSEARG% %%i in (%CURRTIME%) Do Set HHMM=3D%%i%%j%%k
=0A=

ren "D:\BACKUP\postgres_db.backup" =
"postgres_db_%YYYYMMDD%_%HHMM%.backup"
=0A=

del currdate.tmp
del currtime.tmp
=0A=
3. I scheduled the jobs in schedule task, that is in =
control pannel,
=0A=
  a.  Task : -  Create new job =
name...
=0A=
dir=3Dltr>          &nb=
sp;        start in : D:\BACKUP\
=0A=
dir=3Dltr>          &nb=
sp;       RUN as : your login name
=0A=
dir=3Dltr>          &nb=
sp;   put a tick mark in Enabled [scheduled task runs at =
specified time]
=0A=
 
=0A=
 b. Schedule..
=0A=
     schedule task: =
Daily     start time : 12.00 am .... and go to =
Advance
=0A=
        =
tick    Repeat task   ... Every column give =
(Hours u want) (mintues and hours)
=0A=
dir=3Dltr>        Duration &=
nbsp; 24...... give OK 
=0A=
 
=0A=
C. Settings  :     =
tick    Wake the computer to run this task..
=0A=
 
=0A=
d. Security  : check the login =
permissions..   and clik ok ... check the backup job stored =
place..
=0A=
 
=0A=
Thanks & Regards
=0A=
Jayakumar M
=0A=
 
=0A=
 
=0A=
 
=0A=
size=3D2> 

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..
------_=_NextPart_001_01C7D5C0.9A92C333--

Re: Backup Scheduler...

am 07.08.2007 07:37:59 von Jayakumar_Mukundaraju

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7D8B5.5B30A43B
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Richard,
=20
Thanks for the timely help... I did same as u sent.. Now it is working =
fine...
=20
Once again thankyou,
=20
Thanks & Regards
Jayakumar M
India.

________________________________

From: Richard Broersma Jr [mailto:rabroersma@yahoo.com]
Sent: Thu 7/26/2007 7:30 PM
To: Jayakumar_Mukundaraju; Vishal Arora; =
ashish.karalkar@info-spectrum.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup Scheduler...




--- Jayakumar_Mukundaraju wrote:

> Dear Visha/Ashish,
>=20
> 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
>=20

The solution that I use is found on this link:
http://archives.postgresql.org/pgsql-general/2006-12/msg0148 6.php

Maybe be it can give you some ideas that you can use in your bat script =
file.
Regards,
Richard Broersma Jr.





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.

------_=_NextPart_001_01C7D8B5.5B30A43B
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Re: [ADMIN] Backup Scheduler...=0A=
=0A=
=0A=
=0A=

=0A=
Dear =
Richard,
=0A=
 
=0A=
Thanks for the timely help... =
I did same as u sent.. Now it is working fine...
=0A=
 
=0A=
Once again =
thankyou,
=0A=
 
=0A=
Thanks & =
Regards
=0A=
Jayakumar M
=0A=
India.
=0A=

=0A=

=0A=
From: Richard Broersma Jr =
[mailto:rabroersma@yahoo.com]
Sent: Thu 7/26/2007 7:30 =
PM
To: Jayakumar_Mukundaraju; Vishal Arora; =
ashish.karalkar@info-spectrum.com; =
pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup =
Scheduler...

=0A=

=0A=

--- Jayakumar_Mukundaraju =
<Jayakumar_Mukundaraju@satyam.com> wrote:

> 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


The =
solution that I use is found on this link:
href=3D"http://archives.postgresql.org/pgsql-general/2006-12 /msg01486.php=
">http://archives.postgresql.org/pgsql-general/2006-12/msg01 486.php
R>
Maybe be it can give you some ideas that you can use in your bat =
script file.
Regards,
Richard Broersma =
Jr.

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..
------_=_NextPart_001_01C7D8B5.5B30A43B--