From abr_ora@yahoo.com Wed Nov  19 12:14:08 2008
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 6700B64FDAA
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 19 Nov 2008 08:14:08 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 40548-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 19 Nov 2008 08:14:05 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web65702.mail.ac4.yahoo.com (web65702.mail.ac4.yahoo.com
	[76.13.9.94])
	by mail.postgresql.org (Postfix) with SMTP id 2AD6B64FD99
	for <pgsql-admin@postgresql.org>; Wed, 19 Nov 2008 08:14:04 -0400 (AST)
Received: (qmail 10520 invoked by uid 60001); 19 Nov 2008 12:14:03 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID;
	b=vwI9ZKBFvufOnxZ4VuqPtyR3zG1bS7EhH1Schb+JcBJHT7sZqvWi35QOur86kiLaSYwu+64BxiDLsSazQ6+KhU6ilhoh+4HjB4ON4BsoQOKOgcZ5Ci/7M66O9uAXV1Io0Zl8Cg7MSynTGzj0QO9M3eUsiqR6sETfR3u0+fdgEM0=;
X-YMail-OSG: 
 YVrAuRMVM1lPzUbFbuAyerLverltYbZK1rqb960SsPAUlLTSJqAogu7j_EHePeJEAQLXpPptnGtrsINsteVm3iwqRVmXSYxaR5YAmkFa5xzbxQ7AeOKGiVVV0b46vnTll9ko
Received: from [125.209.91.158] by web65702.mail.ac4.yahoo.com via HTTP;
	Wed, 19 Nov 2008 04:14:00 PST
X-Mailer: YahooMailRC/1155.29 YahooMailWebService/0.7.260.1
Date: Wed, 19 Nov 2008 04:14:00 -0800 (PST)
From: Abdul Rahman <abr_ora@yahoo.com>
Subject: Scheduling backup via PgAgent
To: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1971031935-1227096840=:8653"
Message-ID: <282281.8653.qm@web65702.mail.ac4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200811/109
X-Sequence-Number: 30763

--0-1971031935-1227096840=:8653
Content-Type: text/plain; charset=us-ascii

Dear all,

After installing PgAgent I have successfully created a job for auto scheduled backup. But it is not working. I have tried both method i.e. via .bat and via SQL. Kindly guide me and give chance to pay thanks.

Regards,
Abdul Rehman



      
--0-1971031935-1227096840=:8653
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Dear all,<br><br>After installing PgAgent I have successfully created a job for auto scheduled backup. But it is not working. I have tried both method i.e. via .bat and via SQL. Kindly guide me and give chance to pay thanks.<br><br>Regards,<br>Abdul Rehman<br></div></div><br>

      </body></html>
--0-1971031935-1227096840=:8653--



From aroravishal22@hotmail.com Thu Nov  20 05:30:50 2008
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id B3D6E64FE23;
	Thu, 20 Nov 2008 01:30:50 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 15058-02; Thu, 20 Nov 2008 01:30:47 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from blu0-omc1-s12.blu0.hotmail.com (blu0-omc1-s12.blu0.hotmail.com
	[65.55.116.23])
	by mail.postgresql.org (Postfix) with ESMTP id 8FD9264FE35;
	Thu, 20 Nov 2008 01:30:47 -0400 (AST)
Received: from BLU149-W10 ([65.55.116.9]) by blu0-omc1-s12.blu0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Wed, 19 Nov 2008 21:30:46 -0800
Message-ID: <BLU149-W10CF90550612EDA85696E7A90C0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_4135560d-3702-4fdb-80d4-fb0846ccddc4_"
X-Originating-IP: [59.160.193.34]
From: Vishal Arora <aroravishal22@hotmail.com>
To: <abr_ora@yahoo.com>, <pgsql-admin@postgresql.org>
CC: <pgsql-general@postgresql.org>
Subject: Re: Scheduling backup via PgAgent
Date: Thu, 20 Nov 2008 11:00:45 +0530
Importance: Normal
In-Reply-To: <282281.8653.qm@web65702.mail.ac4.yahoo.com>
References: <282281.8653.qm@web65702.mail.ac4.yahoo.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 20 Nov 2008 05:30:46.0140 (UTC)
	FILETIME=[238663C0:01C94AD1]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200811/123
X-Sequence-Number: 30777

--_4135560d-3702-4fdb-80d4-fb0846ccddc4_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


What is the error message you are getting. Can you pass the bat file or sql=
 file.=20

Date: Wed=2C 19 Nov 2008 04:14:00 -0800From: abr_ora@yahoo.comSubject: [ADM=
IN] Scheduling backup via PgAgentTo: pgsql-admin@postgresql.orgCC: pgsql-ge=
neral@postgresql.org



Dear all=2CAfter installing PgAgent I have successfully created a job for a=
uto scheduled backup. But it is not working. I have tried both method i.e. =
via .bat and via SQL. Kindly guide me and give chance to pay thanks.Regards=
=2CAbdul Rehman
_________________________________________________________________
Search for videos of Bollywood=2C Hollywood=2C Mollywood and every other wo=
od=2C only on Live.com=20
http://www.live.com/?scope=3Dvideo&form=3DMICOAL=

--_4135560d-3702-4fdb-80d4-fb0846ccddc4_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
</style>
</head>
<body class=3D'hmmessage'>
What is the error message you are getting. Can you pass the bat file or sql=
 file. <BR><BR>
<HR id=3DstopSpelling>
Date: Wed=2C 19 Nov 2008 04:14:00 -0800<BR>From: abr_ora@yahoo.com<BR>Subje=
ct: [ADMIN] Scheduling backup via PgAgent<BR>To: pgsql-admin@postgresql.org=
<BR>CC: pgsql-general@postgresql.org<BR><BR>
<STYLE>
.ExternalClass DIV
{=3B}
</STYLE>

<DIV style=3D"FONT-SIZE: 12pt=3B FONT-FAMILY: times new roman=2Cnew york=2C=
times=2Cserif">
<DIV>Dear all=2C<BR><BR>After installing PgAgent I have successfully create=
d a job for auto scheduled backup. But it is not working. I have tried both=
 method i.e. via .bat and via SQL. Kindly guide me and give chance to pay t=
hanks.<BR><BR>Regards=2C<BR>Abdul Rehman<BR></DIV></DIV><BR><br /><hr />Wha=
t's on the ramp today could be on the streets tomorrow. Keep up with trends=
 on MSN Lifestyle  <a href=3D'http://lifestyle.in.msn.com/' target=3D'_new'=
>Try it!</a></body>
</html>=

--_4135560d-3702-4fdb-80d4-fb0846ccddc4_--



From abr_ora@yahoo.com Thu Nov  20 05:41:27 2008
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D8D9964FD16
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 20 Nov 2008 01:41:27 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 17552-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 20 Nov 2008 01:41:25 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web65713.mail.ac4.yahoo.com (web65713.mail.ac4.yahoo.com
	[76.13.9.105])
	by mail.postgresql.org (Postfix) with SMTP id 72DB664FD04
	for <pgsql-admin@postgresql.org>; Thu, 20 Nov 2008 01:41:24 -0400 (AST)
Received: (qmail 19204 invoked by uid 60001); 20 Nov 2008 05:41:23 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID;
	b=kw0Fd0Mp8SiPsTUk4fU2+NqiTmg31XVr9ba1HHkNQANyXnuDjGXA7y7TZT3pGsVPP+PcTzTf44YfJe8qcgkuHUgmtRmMWTVK2PrO9VKUWxG4pmEZLxqzwJl04RwEp/A3mYLcvJJrL8vSTc7cj8IvAknQoMKjfWfoFEcQNoxwAX4=;
X-YMail-OSG: 
 Z.5N05AVM1nBjT7kfhBVn3dIe1OXvcZzitrC8_DiPC40R.hRAmRUDZpeQV1_s_JtKBfg86t8sfpNzMrMZqSIrxFtAn1z25crB7N6IRnmGc5J2gCMIZO9xo9A19HiBT7OFjXGuJnWzhzFXYL.rPpwjofTJ6g3NNCPt3fjSO8R
Received: from [125.209.91.158] by web65713.mail.ac4.yahoo.com via HTTP;
	Wed, 19 Nov 2008 21:41:23 PST
X-Mailer: YahooMailRC/1155.32 YahooMailWebService/0.7.260.1
Date: Wed, 19 Nov 2008 21:41:23 -0800 (PST)
From: Abdul Rahman <abr_ora@yahoo.com>
Subject: Re: Scheduling backup via PgAgent
To: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-223108646-1227159683=:19089"
Message-ID: <222461.19089.qm@web65713.mail.ac4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200811/124
X-Sequence-Number: 30778

--0-223108646-1227159683=:19089
Content-Type: text/plain; charset=us-ascii

Oh! 

I have got the mistake made by me. Actually I didn't start the PostgreSQL Scheduling Agent - pgAgent service. Now its working fine. 

I also have attached the complete document of my work for the sake of knowledge share. 

Regards,
Abdul Rehman.



      
--0-223108646-1227159683=:19089
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Oh! <br><br>I have got the mistake made by me. Actually I didn't start the <span style="font-weight: bold;">PostgreSQL Scheduling Agent - pgAgent </span>service. Now its working fine. <br><br>I also have attached the complete document of my work for the sake of knowledge share. <br><br>Regards,<br>Abdul Rehman.<br></div></div><br>

      </body></html>
--0-223108646-1227159683=:19089--



From dpage@pgadmin.org Thu Nov  20 10:07:48 2008
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E301B650172
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 20 Nov 2008 06:07:48 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 94451-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 20 Nov 2008 06:07:44 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hs-out-0708.google.com (hs-out-0708.google.com
 [64.233.178.244])
	by mail.postgresql.org (Postfix) with ESMTP id 55ADE6500FD
	for <pgsql-admin@postgresql.org>; Thu, 20 Nov 2008 06:07:44 -0400 (AST)
Received: by hs-out-0708.google.com with SMTP id x43so190058hsb.3
	for <pgsql-admin@postgresql.org>; Thu, 20 Nov 2008 02:07:43 -0800 (PST)
Received: by 10.151.114.9 with SMTP id r9mr3937186ybm.81.1227175663032;
	Thu, 20 Nov 2008 02:07:43 -0800 (PST)
Received: by 10.150.156.1 with HTTP; Thu, 20 Nov 2008 02:07:42 -0800 (PST)
Message-ID: <937d27e10811200207q64072936jf54e63ed7a629d22@mail.gmail.com>
Date: Thu, 20 Nov 2008 10:07:42 +0000
From: "Dave Page" <dpage@pgadmin.org>
To: "Abdul Rahman" <abr_ora@yahoo.com>
Subject: Re: [GENERAL] Scheduling backup via PgAgent
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org
In-Reply-To: <222461.19089.qm@web65713.mail.ac4.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <222461.19089.qm@web65713.mail.ac4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200811/126
X-Sequence-Number: 30780

On Thu, Nov 20, 2008 at 5:41 AM, Abdul Rahman <abr_ora@yahoo.com> wrote:
> Oh!
>
> I have got the mistake made by me. Actually I didn't start the PostgreSQL
> Scheduling Agent - pgAgent service. Now its working fine.
>
> I also have attached the complete document of my work for the sake of
> knowledge share.

I think you forgot the attachment. It would be useful if you could add
it to the wiki though: http://wiki.postgresql.org/


-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com