Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result = is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not workin= g

From: Vishal Arora <=3Bar= oravishal22@hotmail.com>=3B
To: abr_ora@yahoo.com
Sent: Tuesday=2C November 25=2C 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is N= OT running

Is the service running properly=2C try to schedule a new job and see the re= sults.

Date: Mon=2C 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

No error message appeared. Because NO statistics is availab= le for the job. It reflects that it is not running.

----- Forwarded Message ----From: Vishal Arora <=3Ba= roravishal22@hotmail.com>=3B
To:<= /SPAN> abr_ora@yahoo.com=3B pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
<= SPAN style=3D"FONT-WEIGHT: bold">Sent: Tuesday=2C November 25=2C= 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have se= t for scheduling the job.

Date: Sun=2C 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subje= ct: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postg= resql.org
CC: pgsql-admin@postgresql.org

Dear all=2C

I =3B installed PgAgent and started its service= and successfully scheduled a backup and got 100% result. Now the same Job = is not working even I reinstalled PgAgent but failed to get result.
Regards=2C
Abdul Rehman.

Team India gets set to thwart Australia's quest for the final frontier. Cat= ch the action on MSN Try it now!

Calling TV buffs! Get TV listings=2C gossip on your fave stars and updates = on hot new shows Try it now!

Free up your senses. E= xperience reality up close on MSN video Try it! = --_d04b0dd3-0cae-4222-8456-ba11cf105520_-- From abr_ora@yahoo.com Thu Nov 27 07:52:09 2008 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E1B4765017B for ; Thu, 27 Nov 2008 03:52:09 -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 90610-10 for ; Thu, 27 Nov 2008 03:52:06 -0400 (AST) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id 36B2F64FDE9 for ; Thu, 27 Nov 2008 03:52:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web65704.mail.ac4.yahoo.com (web65704.mail.ac4.yahoo.com [76.13.9.96]) by mx3.hub.org (Postfix) with SMTP id 1A84B37BDBA for ; Thu, 27 Nov 2008 03:43:27 -0400 (AST) Received: (qmail 29597 invoked by uid 60001); 27 Nov 2008 07:43:25 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=Pkg4vQWkK4aYQQ7n5g5Hl+n+lj1yZDMrLnHTZNfsIngkRVeYzbWNaVxJUHdF2jiU1NNniKHBjicL/EFlGS7+UHUrEeuw29MS9URXFmfP09jO+X3nEel/kt14Ciq8IpACO5BF+nsBqELcVHOKua/oqtpgdijvwkqF5jrJ0UzudPw=; X-YMail-OSG: GZCuHEsVM1mlP541ldDa8_oS15iQnR5dvU9M3CcMDNC8Di4.s.4Sbf9zkS7ueAuuSYnpnOJ.mli0Nlj2r.nqVMwTS8aWSI.G94dPIGI3OwCe3zNLm7YqSlwe5CaG59YjZn4gEt8fDeDnseCXnSGUdui5y9g427qjZlGkju0WjNf32xQ- Received: from [125.209.91.158] by web65704.mail.ac4.yahoo.com via HTTP; Wed, 26 Nov 2008 23:43:25 PST X-Mailer: YahooMailRC/1155.32 YahooMailWebService/0.7.260.1 References: <445095.85132.qm@web65712.mail.ac4.yahoo.com> <239268.43396.qm@web65707.mail.ac4.yahoo.com> Date: Wed, 26 Nov 2008 23:43:25 -0800 (PST) From: Abdul Rahman Subject: Re: PgAgent Job Scehduler is NOT running To: Vishal Arora , pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1358758082-1227771805=:29281" Message-ID: <648789.29281.qm@web65704.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/159 X-Sequence-Number: 30813 --0-1358758082-1227771805=:29281 Content-Type: text/plain; charset=us-ascii Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. ________________________________ From: Vishal Arora To: abr_ora@yahoo.com; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc ________________________________ Date: Tue, 25 Nov 2008 02:32:46 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . ________________________________ From: Vishal Arora To: abr_ora@yahoo.com Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. ________________________________ Date: Mon, 24 Nov 2008 23:23:15 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. ----- Forwarded Message ---- From: Vishal Arora To: abr_ora@yahoo.com; pgsql-general@postgresql.org Cc: pgsql-admin@postgresql.org Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. ________________________________ Date: Sun, 23 Nov 2008 23:51:46 -0800 From: abr_ora@yahoo.com Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: pgsql-admin@postgresql.org Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! ________________________________ Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! ________________________________ Free up your senses. Experience reality up close on MSN video Try it! --0-1358758082-1227771805=:29281 Content-Type: text/html; charset=us-ascii
Thanks Vishal,

I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error:

could not open the file "D:\xxx.backup":Permission denied.

I tried to perform the task from both (normal & postgres) users of OS. But no benefit.

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Wednesday, November 26, 2008 10:25:11 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Try to follow the steps given in following link -

http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc

Date: Tue, 25 Nov 2008 02:32:46 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working .

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com
Sent: Tuesday, November 25, 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Is the service running properly, try to schedule a new job and see the results.

Date: Mon, 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

No error message appeared. Because NO statistics is available for the job. It reflects that it is not running.

----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, November 25, 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have set for scheduling the job.

Date: Sun, 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org

Dear all,

I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result.

Regards,
Abdul Rehman.

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now!

Free up your senses. Experience reality up close on MSN video Try it!

--0-1358758082-1227771805=:29281-- From aroravishal22@hotmail.com Thu Nov 27 12:27:31 2008 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7082364FC92; Thu, 27 Nov 2008 08:27:31 -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 52404-05; Thu, 27 Nov 2008 08:27:27 -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-s10.blu0.hotmail.com (blu0-omc1-s10.blu0.hotmail.com [65.55.116.21]) by mail.postgresql.org (Postfix) with ESMTP id 57F5C64FDE9; Thu, 27 Nov 2008 08:27:27 -0400 (AST) Received: from BLU149-W40 ([65.55.116.8]) by blu0-omc1-s10.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Thu, 27 Nov 2008 04:27:26 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_e209680b-6d59-484f-b366-7d69b96dd974_" X-Originating-IP: [59.160.193.34] From: Vishal Arora To: , CC: Subject: Re: PgAgent Job Scehduler is NOT running Date: Thu, 27 Nov 2008 17:57:26 +0530 Importance: Normal In-Reply-To: <648789.29281.qm@web65704.mail.ac4.yahoo.com> References: <445095.85132.qm@web65712.mail.ac4.yahoo.com> <239268.43396.qm@web65707.mail.ac4.yahoo.com> <648789.29281.qm@web65704.mail.ac4.yahoo.com> MIME-Version: 1.0 X-OriginalArrivalTime: 27 Nov 2008 12:27:26.0005 (UTC) FILETIME=[817F4E50:01C9508B] 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/162 X-Sequence-Number: 30816 --_e209680b-6d59-484f-b366-7d69b96dd974_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Well in that case you need to check if you have relevant entries in pgpass.= conf file.=20 Date: Wed=2C 26 Nov 2008 23:43:25 -0800From: abr_ora@yahoo.comSubject: Re: = [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org Thanks Vishal=2CI followed the document and now the statistics of the job i= s appearing and showing successful but actually backup is not made via this= job. In output tab it gives the following error:could not open the file "D= :\xxx.backup":Permission denied.I tried to perform the task from both (norm= al & postgres) users of OS. But no benefit.=20 From: Vishal Arora To: abr_ora@yahoo.com=3B pgsq= l-admin@postgresql.orgCc: pgsql-general@postgresql.orgSent: Wednesday=2C No= vember 26=2C 2008 10:25:11 PMSubject: RE: [ADMIN] PgAgent Job Scehduler is = NOT running Try to follow the steps given in following link - http://wiki.postgresql.o= rg/wiki/Image:PgAgent_for_windows.doc Date: Tue=2C 25 Nov 2008 02:32:46 -0800From: abr_ora@yahoo.comSubject: Re: = [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema a= nd reworked. But the result is same. ???. Even entries in the concerned pga= _tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora To: abr_ora@yahoo.comSent: Tu= esday=2C November 25=2C 2008 3:08:05 PMSubject: RE: [ADMIN] PgAgent Job Sce= hduler is NOT running Is the service running properly=2C try to schedule a new job and see the re= sults. Date: Mon=2C 24 Nov 2008 23:23:15 -0800From: abr_ora@yahoo.comSubject: Re: = [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org No error message appeared. Because NO statistics is available for the job. = It reflects that it is not running.=20 ----- Forwarded Message ----From: Vishal Arora T= o: abr_ora@yahoo.com=3B pgsql-general@postgresql.orgCc: pgsql-admin@postgre= sql.orgSent: Tuesday=2C November 25=2C 2008 11:47:33 AMSubject: RE: [ADMIN]= PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have se= t for scheduling the job.=20 Date: Sun=2C 23 Nov 2008 23:51:46 -0800From: abr_ora@yahoo.comSubject: [ADM= IN] PgAgent Job Scehduler is NOT runningTo: pgsql-general@postgresql.orgCC:= pgsql-admin@postgresql.org Dear all=2CI installed PgAgent and started its service and successfully sc= heduled a backup and got 100% result. Now the same Job is not working even = I reinstalled PgAgent but failed to get result. Regards=2CAbdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Cat= ch the action on MSN Try it now! Calling TV buffs! Get TV listings=2C gossip on your fave stars and updates = on hot new shows Try it now! Free up your senses. Experience reality up close on MSN video Try it! _________________________________________________________________ Register once and play all contests. Increase your scores with bonus credit= s for logging in daily on MSN. http://specials.msn.co.in/msncontest/index.aspx= --_e209680b-6d59-484f-b366-7d69b96dd974_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Well in that case you need to check if you have relevant entries in pgpass.= conf file.

Date: Wed=2C 26 Nov 2008 23:43:25 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

Thanks Vishal=2C

I followed the document and now the statistics= of the job is appearing and showing suc= cessful but actually backup is not made via this job. In output tab it gives the following error:
=
could not open the file "D:\xxx.backup":Permission denied.

I tri= ed to perform the task from both (normal &=3B postgres) users of OS. But= no benefit.

From: Vishal Arora <=3Bar= oravishal22@hotmail.com>=3B
To: abr_ora@yahoo.com=3B pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Wednesday=2C November 26= =2C 2008 10:25:11 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Try to follow the steps given in following link -
=3B
http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc

Date: Tue=2C 25 Nov 2008 02:32:46 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result = is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not workin= g .

From: Vishal Arora <=3Bar= oravishal22@hotmail.com>=3B
To: abr_ora@yahoo.com
Sent: Tuesday=2C November 25=2C 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is N= OT running

Is the service running properly=2C try to schedule a new job and see the re= sults.

Date: Mon=2C 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

No error message appeared. Because NO statistics is availab= le for the job. It reflects that it is not running.

----- Forwarded Message ----From: Vishal Arora <=3Ba= roravishal22@hotmail.com>=3B
To:<= /SPAN> abr_ora@yahoo.com=3B pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
<= SPAN style=3D"FONT-WEIGHT: bold">Sent: Tuesday=2C November 25=2C= 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have se= t for scheduling the job.

Date: Sun=2C 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subje= ct: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postg= resql.org
CC: pgsql-admin@postgresql.org

Dear all=2C

I =3B installed PgAgent and started its service= and successfully scheduled a backup and got 100% result. Now the same Job = is not working even I reinstalled PgAgent but failed to get result.
Regards=2C
Abdul Rehman.

Team India gets set to thwart Australia's quest for the final frontier. Cat= ch the action on MSN Try it now!

Calling TV buffs! Get TV listings=2C gossip on your fave stars and updates = on hot new shows Try it now!

Free up your senses. Experience reality up close on MSN video Try it!

Team India gets set to thwart Australia's quest for the f= inal frontier. Catch the action on MSN Try it now! = --_e209680b-6d59-484f-b366-7d69b96dd974_-- From abr_ora@yahoo.com Fri Nov 28 05:12:28 2008 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2BA1A64FC65 for ; Fri, 28 Nov 2008 01:12:28 -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 88003-05 for ; Fri, 28 Nov 2008 01:12:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web65703.mail.ac4.yahoo.com (web65703.mail.ac4.yahoo.com [76.13.9.95]) by mail.postgresql.org (Postfix) with SMTP id D6DE764FC12 for ; Fri, 28 Nov 2008 01:12:24 -0400 (AST) Received: (qmail 36877 invoked by uid 60001); 28 Nov 2008 05:12:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=3LtXQknBDWrfZqUIQFIDAxZcfNP3F/xFZaZYvLUklcDG/lodziwt3TBU6lQ/BwedcySVcM1yQSmIJF4bWa9mHSCY2i/hdtJ+tJzVUkj8nA9Y3/VcBN9fcR4v2i2tD1wWdeLSOj9oRQIgLovt8tO/VkqIyUpFHYClPYgagvsj0JA=; X-YMail-OSG: 9vK.oCcVM1nyjBK6iBR0m0U63zUfiFczIbBaaoVaUL0lDMisLBwZdsLCXeTog6mgzOulEe3YW3V31V.1WFx5rGddqlL.ZiV0vmQPyrUtKo.szS0Bt_TR7o1rjjLwzvec7QZaI78jPwlO.sdjANv4h2X_kk3bVGJ8dDHyuGnWfQUMNbE- Received: from [206.49.106.4] by web65703.mail.ac4.yahoo.com via HTTP; Thu, 27 Nov 2008 21:12:23 PST X-Mailer: YahooMailRC/1155.32 YahooMailWebService/0.7.260.1 References: <445095.85132.qm@web65712.mail.ac4.yahoo.com> <239268.43396.qm@web65707.mail.ac4.yahoo.com> <648789.29281.qm@web65704.mail.ac4.yahoo.com> Date: Thu, 27 Nov 2008 21:12:23 -0800 (PST) From: Abdul Rahman Subject: Re: PgAgent Job Scehduler is NOT running To: Vishal Arora , pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-42559043-1227849143=:36710" Message-ID: <593499.36710.qm@web65703.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/167 X-Sequence-Number: 30821 --0-42559043-1227849143=:36710 Content-Type: text/plain; charset=us-ascii I searched but didn't find any pgpass.conf file. ________________________________ From: Vishal Arora To: abr_ora@yahoo.com; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Well in that case you need to check if you have relevant entries in pgpass.conf file. ________________________________ Date: Wed, 26 Nov 2008 23:43:25 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. ________________________________ From: Vishal Arora To: abr_ora@yahoo.com; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc ________________________________ Date: Tue, 25 Nov 2008 02:32:46 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . ________________________________ From: Vishal Arora To: abr_ora@yahoo.com Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. ________________________________ Date: Mon, 24 Nov 2008 23:23:15 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. ----- Forwarded Message ---- From: Vishal Arora To: abr_ora@yahoo.com; pgsql-general@postgresql.org Cc: pgsql-admin@postgresql.org Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. ________________________________ Date: Sun, 23 Nov 2008 23:51:46 -0800 From: abr_ora@yahoo.com Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: pgsql-admin@postgresql.org Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! ________________________________ Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! ________________________________ Free up your senses. Experience reality up close on MSN video Try it! ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! --0-42559043-1227849143=:36710 Content-Type: text/html; charset=us-ascii
I searched but didn't find any pgpass.conf file.

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Well in that case you need to check if you have relevant entries in pgpass.conf file.

Date: Wed, 26 Nov 2008 23:43:25 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

Thanks Vishal,

I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error:

could not open the file "D:\xxx.backup":Permission denied.

I tried to perform the task from both (normal & postgres) users of OS. But no benefit.

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Wednesday, November 26, 2008 10:25:11 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Try to follow the steps given in following link -

http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc

Date: Tue, 25 Nov 2008 02:32:46 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working .

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com
Sent: Tuesday, November 25, 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Is the service running properly, try to schedule a new job and see the results.

Date: Mon, 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

No error message appeared. Because NO statistics is available for the job. It reflects that it is not running.

----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, November 25, 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have set for scheduling the job.

Date: Sun, 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org

Dear all,

I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result.

Regards,
Abdul Rehman.

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now!

Free up your senses. Experience reality up close on MSN video Try it!

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

--0-42559043-1227849143=:36710-- From abr_ora@yahoo.com Fri Nov 28 05:57:07 2008 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9BABD64FCC9 for ; Fri, 28 Nov 2008 01:57:07 -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 96201-01 for ; Fri, 28 Nov 2008 01:57:04 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web65706.mail.ac4.yahoo.com (web65706.mail.ac4.yahoo.com [76.13.9.98]) by mail.postgresql.org (Postfix) with SMTP id 49DB864FC3A for ; Fri, 28 Nov 2008 01:57:04 -0400 (AST) Received: (qmail 13909 invoked by uid 60001); 28 Nov 2008 05:57: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=i3j4nZa4/+g8mwTMjUFuVyfJj0WMivHMuerZ9OjNhCFc1TDPucEIC/j1NHRzK+wuLXbDKTbXMnp7nBftA2FyQ8eZr0qRSF5gpM/8uVtfGFN+PROKiuwkNshzzgkfGO8+uNC3DPIfOi0JkqXaACuT5AeU4llWbv8or7620QHxPYc=; X-YMail-OSG: V7g4SYwVM1nfly4CahW8AiFZrGRjKeVn3AGmXsdTj1Bnv8TcwuGHlaxEElKNh_2d9qm2J3lbplZorwFZydgrQ2iVpZE.xpAjlc30ll4b5HCCkTuHsxQ3vVyVcFepNVngtyM7.e6vxHQQVVhALYwH0T3s2xUCpvM_Fewt0ik2OsElO3w- Received: from [125.209.91.158] by web65706.mail.ac4.yahoo.com via HTTP; Thu, 27 Nov 2008 21:57:02 PST X-Mailer: YahooMailRC/1155.32 YahooMailWebService/0.7.260.1 Date: Thu, 27 Nov 2008 21:57:02 -0800 (PST) From: Abdul Rahman Subject: Re: PgAgent Job Scehduler is NOT running To: Vishal Arora , pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-321477651-1227851822=:13247" Message-ID: <203472.13247.qm@web65706.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/168 X-Sequence-Number: 30822 --0-321477651-1227851822=:13247 Content-Type: text/plain; charset=us-ascii I have found via cmd prompt. My Computer (GUI) is not showing the path and file (pgpass.conf). However, the size of this file is 0kb i.e. nothing is written in this file. ----- Forwarded Message ---- From: Abdul Rahman To: Vishal Arora ; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Friday, November 28, 2008 10:12:23 AM Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running I searched but didn't find any pgpass.conf file. ________________________________ From: Vishal Arora To: abr_ora@yahoo.com; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Well in that case you need to check if you have relevant entries in pgpass.conf file. ________________________________ Date: Wed, 26 Nov 2008 23:43:25 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. ________________________________ From: Vishal Arora To: abr_ora@yahoo.com; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc ________________________________ Date: Tue, 25 Nov 2008 02:32:46 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . ________________________________ From: Vishal Arora To: abr_ora@yahoo.com Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. ________________________________ Date: Mon, 24 Nov 2008 23:23:15 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. ----- Forwarded Message ---- From: Vishal Arora To: abr_ora@yahoo.com; pgsql-general@postgresql.org Cc: pgsql-admin@postgresql.org Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. ________________________________ Date: Sun, 23 Nov 2008 23:51:46 -0800 From: abr_ora@yahoo.com Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: pgsql-admin@postgresql.org Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! ________________________________ Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! ________________________________ Free up your senses. Experience reality up close on MSN video Try it! ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! --0-321477651-1227851822=:13247 Content-Type: text/html; charset=us-ascii
I have found via cmd prompt. My Computer (GUI) is not showing the path and file (pgpass.conf). However, the size of this file is 0kb i.e. nothing is written in this file.

----- Forwarded Message ----
From: Abdul Rahman <abr_ora@yahoo.com>
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Friday, November 28, 2008 10:12:23 AM
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running

I searched but didn't find any pgpass.conf file.

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Well in that case you need to check if you have relevant entries in pgpass.conf file.

Date: Wed, 26 Nov 2008 23:43:25 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

Thanks Vishal,

I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error:

could not open the file "D:\xxx.backup":Permission denied.

I tried to perform the task from both (normal & postgres) users of OS. But no benefit.

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Wednesday, November 26, 2008 10:25:11 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Try to follow the steps given in following link -

http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc

Date: Tue, 25 Nov 2008 02:32:46 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working .

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com
Sent: Tuesday, November 25, 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Is the service running properly, try to schedule a new job and see the results.

Date: Mon, 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

No error message appeared. Because NO statistics is available for the job. It reflects that it is not running.

----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, November 25, 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have set for scheduling the job.

Date: Sun, 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org

Dear all,

I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result.

Regards,
Abdul Rehman.

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now!

Free up your senses. Experience reality up close on MSN video Try it!

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

--0-321477651-1227851822=:13247-- From abr_ora@yahoo.com Fri Nov 28 10:11:40 2008 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8043D64FD7D for ; Fri, 28 Nov 2008 06:11:40 -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 49201-10 for ; Fri, 28 Nov 2008 06:11:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web65708.mail.ac4.yahoo.com (web65708.mail.ac4.yahoo.com [76.13.9.100]) by mail.postgresql.org (Postfix) with SMTP id EC5CC64FC3A for ; Fri, 28 Nov 2008 06:11:36 -0400 (AST) Received: (qmail 57271 invoked by uid 60001); 28 Nov 2008 10:11:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=PRpwi4cnS96UulzgSC30u60sVEva6r6wdUnrOYJRywhWhS1LI1kPBDBF6zMqJfA8CcjXzEaK4tP53/aaDj28GnuEe0DD+uf2k1qqsc/abOb2RMwMHNoaDNFci01gDybajOTVUlg34/JIL6bDJIHBcwS9GcYE2gkvuoue7XvA5Ko=; X-YMail-OSG: LYjkUGUVM1nMibxpp9..101BKiqr.B7.44TqlIYz2Gp9CqeJDG4eYu4494HVeV0xP1.yPloGA9BKF6XIZb6tz_wfy7WQuj2ZJ85Y8O91XFWsRMnU6xKp1TiE9CQTgKIwY7opl5hPk91TVe5fZzTKUgLew_c3MzivxllO2PQPqrjWvJw- Received: from [125.209.91.158] by web65708.mail.ac4.yahoo.com via HTTP; Fri, 28 Nov 2008 02:11:34 PST X-Mailer: YahooMailRC/1155.32 YahooMailWebService/0.7.260.1 References: <445095.85132.qm@web65712.mail.ac4.yahoo.com> <239268.43396.qm@web65707.mail.ac4.yahoo.com> <648789.29281.qm@web65704.mail.ac4.yahoo.com> Date: Fri, 28 Nov 2008 02:11:34 -0800 (PST) From: Abdul Rahman Subject: Re: PgAgent Job Scehduler is NOT running To: Vishal Arora , pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1465462042-1227867094=:57176" Message-ID: <68882.57176.qm@web65708.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/170 X-Sequence-Number: 30824 --0-1465462042-1227867094=:57176 Content-Type: text/plain; charset=us-ascii That's it! Arora your document (http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc) is better than the best. The error was of postgress user rights and nothing else. After granting rights to postgres Its really running well. Thanks. ________________________________ From: Vishal Arora To: abr_ora@yahoo.com; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Well in that case you need to check if you have relevant entries in pgpass.conf file. ________________________________ Date: Wed, 26 Nov 2008 23:43:25 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. ________________________________ From: Vishal Arora To: abr_ora@yahoo.com; pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc ________________________________ Date: Tue, 25 Nov 2008 02:32:46 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . ________________________________ From: Vishal Arora To: abr_ora@yahoo.com Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. ________________________________ Date: Mon, 24 Nov 2008 23:23:15 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. ----- Forwarded Message ---- From: Vishal Arora To: abr_ora@yahoo.com; pgsql-general@postgresql.org Cc: pgsql-admin@postgresql.org Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. ________________________________ Date: Sun, 23 Nov 2008 23:51:46 -0800 From: abr_ora@yahoo.com Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: pgsql-admin@postgresql.org Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! ________________________________ Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! ________________________________ Free up your senses. Experience reality up close on MSN video Try it! ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! --0-1465462042-1227867094=:57176 Content-Type: text/html; charset=us-ascii
That's it!

Arora your document (http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc) is better than the best. The error was of postgress user rights and nothing else. After granting rights to postgres Its really running well.

Thanks.
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Well in that case you need to check if you have relevant entries in pgpass.conf file.

Date: Wed, 26 Nov 2008 23:43:25 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

Thanks Vishal,

I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error:

could not open the file "D:\xxx.backup":Permission denied.

I tried to perform the task from both (normal & postgres) users of OS. But no benefit.

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Wednesday, November 26, 2008 10:25:11 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Try to follow the steps given in following link -

http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc

Date: Tue, 25 Nov 2008 02:32:46 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working .

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com
Sent: Tuesday, November 25, 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Is the service running properly, try to schedule a new job and see the results.

Date: Mon, 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

No error message appeared. Because NO statistics is available for the job. It reflects that it is not running.

----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, November 25, 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have set for scheduling the job.

Date: Sun, 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org

Dear all,

I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result.

Regards,
Abdul Rehman.

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now!

Free up your senses. Experience reality up close on MSN video Try it!

Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

--0-1465462042-1227867094=:57176-- From aroravishal22@hotmail.com Fri Nov 28 16:46:08 2008 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3C8F964FC76; Fri, 28 Nov 2008 12:46: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 35260-07; Fri, 28 Nov 2008 12:46:04 -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-s4.blu0.hotmail.com (blu0-omc1-s4.blu0.hotmail.com [65.55.116.15]) by mail.postgresql.org (Postfix) with ESMTP id 2F06A64FD44; Fri, 28 Nov 2008 12:46:04 -0400 (AST) Received: from BLU149-W61 ([65.55.116.9]) by blu0-omc1-s4.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Fri, 28 Nov 2008 08:46:03 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_2889696c-3135-4762-9bd3-fcc0e8e6e800_" X-Originating-IP: [117.192.102.239] From: Vishal Arora To: , CC: Subject: Re: PgAgent Job Scehduler is NOT running Date: Fri, 28 Nov 2008 22:16:03 +0530 Importance: Normal In-Reply-To: <593499.36710.qm@web65703.mail.ac4.yahoo.com> References: <445095.85132.qm@web65712.mail.ac4.yahoo.com> <239268.43396.qm@web65707.mail.ac4.yahoo.com> <648789.29281.qm@web65704.mail.ac4.yahoo.com> <593499.36710.qm@web65703.mail.ac4.yahoo.com> MIME-Version: 1.0 X-OriginalArrivalTime: 28 Nov 2008 16:46:03.0073 (UTC) FILETIME=[CCCDBB10:01C95178] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.118 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RCVD_IN_SORBS_WEB=1.117 X-Spam-Level: * X-Archive-Number: 200811/172 X-Sequence-Number: 30826 --_2889696c-3135-4762-9bd3-fcc0e8e6e800_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Its located in Application Data folder.=20 Date: Thu=2C 27 Nov 2008 21:12:23 -0800From: abr_ora@yahoo.comSubject: Re: = [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org I searched but didn't find any pgpass.conf file. From: Vishal Arora To: abr_ora@yahoo.com=3B pgsq= l-admin@postgresql.orgCc: pgsql-general@postgresql.orgSent: Thursday=2C Nov= ember 27=2C 2008 5:27:26 PMSubject: RE: [ADMIN] PgAgent Job Scehduler is NO= T running Well in that case you need to check if you have relevant entries in pgpass.= conf file.=20 Date: Wed=2C 26 Nov 2008 23:43:25 -0800From: abr_ora@yahoo.comSubject: Re: = [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org Thanks Vishal=2CI followed the document and now the statistics of the job i= s appearing and showing successful but actually backup is not made via this= job. In output tab it gives the following error:could not open the file "D= :\xxx.backup":Permission denied.I tried to perform the task from both (norm= al & postgres) users of OS. But no benefit.=20 From: Vishal Arora To: abr_ora@yahoo.com=3B pgsq= l-admin@postgresql.orgCc: pgsql-general@postgresql.orgSent: Wednesday=2C No= vember 26=2C 2008 10:25:11 PMSubject: RE: [ADMIN] PgAgent Job Scehduler is = NOT running Try to follow the steps given in following link - http://wiki.postgresql.o= rg/wiki/Image:PgAgent_for_windows.doc Date: Tue=2C 25 Nov 2008 02:32:46 -0800From: abr_ora@yahoo.comSubject: Re: = [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema a= nd reworked. But the result is same. ???. Even entries in the concerned pga= _tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora To: abr_ora@yahoo.comSent: Tu= esday=2C November 25=2C 2008 3:08:05 PMSubject: RE: [ADMIN] PgAgent Job Sce= hduler is NOT running Is the service running properly=2C try to schedule a new job and see the re= sults. Date: Mon=2C 24 Nov 2008 23:23:15 -0800From: abr_ora@yahoo.comSubject: Re: = [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com= =3B pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org No error message appeared. Because NO statistics is available for the job. = It reflects that it is not running.=20 ----- Forwarded Message ----From: Vishal Arora T= o: abr_ora@yahoo.com=3B pgsql-general@postgresql.orgCc: pgsql-admin@postgre= sql.orgSent: Tuesday=2C November 25=2C 2008 11:47:33 AMSubject: RE: [ADMIN]= PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have se= t for scheduling the job.=20 Date: Sun=2C 23 Nov 2008 23:51:46 -0800From: abr_ora@yahoo.comSubject: [ADM= IN] PgAgent Job Scehduler is NOT runningTo: pgsql-general@postgresql.orgCC:= pgsql-admin@postgresql.org Dear all=2CI installed PgAgent and started its service and successfully sc= heduled a backup and got 100% result. Now the same Job is not working even = I reinstalled PgAgent but failed to get result. Regards=2CAbdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Cat= ch the action on MSN Try it now! Calling TV buffs! Get TV listings=2C gossip on your fave stars and updates = on hot new shows Try it now! Free up your senses. Experience reality up close on MSN video Try it! Team India gets set to thwart Australia's quest for the final frontier. Cat= ch the action on MSN Try it now! _________________________________________________________________ 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= --_2889696c-3135-4762-9bd3-fcc0e8e6e800_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Its located in Application Data folder.

Date: Thu=2C 27 Nov 2008 21:12:23 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

I searched but didn't find any pgpass.conf file.

From: Vishal Arora <=3Bar= oravishal22@hotmail.com>=3B
To: abr_ora@yahoo.com=3B pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Thursday=2C November 27=2C= 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Well in that case you need to check if you have relevant entries in pgpass.= conf file.

Date: Wed=2C 26 Nov 2008 23:43:25 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

Thanks Vishal=2C

I followed the document and now the statistics= of the job is appearing and showing suc= cessful but actually backup is not made via this job. In output tab it gives the following error:
=
could not open the file "D:\xxx.backup":Permission denied.

I tri= ed to perform the task from both (normal &=3B postgres) users of OS. But= no benefit.

From: Vishal Arora <=3Bar= oravishal22@hotmail.com>=3B
To: abr_ora@yahoo.com=3B pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Wednesday=2C November 26= =2C 2008 10:25:11 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Try to follow the steps given in following link -
=3B
http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc

Date: Tue=2C 25 Nov 2008 02:32:46 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result = is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not workin= g .

From: Vishal Arora <=3Bar= oravishal22@hotmail.com>=3B
To: abr_ora@yahoo.com
Sent: Tuesday=2C November 25=2C 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is N= OT running

Is the service running properly=2C try to schedule a new job and see the re= sults.

Date: Mon=2C 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subje= ct: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@h= otmail.com=3B pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.or= g

No error message appeared. Because NO statistics is availab= le for the job. It reflects that it is not running.

----- Forwarded Message ----From: Vishal Arora <=3Ba= roravishal22@hotmail.com>=3B
To:<= /SPAN> abr_ora@yahoo.com=3B pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
<= SPAN style=3D"FONT-WEIGHT: bold">Sent: Tuesday=2C November 25=2C= 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have se= t for scheduling the job.

Date: Sun=2C 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subje= ct: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postg= resql.org
CC: pgsql-admin@postgresql.org

Dear all=2C

I =3B installed PgAgent and started its service= and successfully scheduled a backup and got 100% result. Now the same Job = is not working even I reinstalled PgAgent but failed to get result.
Regards=2C
Abdul Rehman.

Team India gets set to thwart Australia's quest for the final frontier. Cat= ch the action on MSN Try it now!

Calling TV buffs! Get TV listings=2C gossip on your fave stars and updates = on hot new shows Try it now!

Free up your senses. Experience reality up close on MSN video Try it!

Team India gets set to thwart Australia's quest for the final frontier. Cat= ch the action on MSN T= ry it now!

What's on the ramp today co= uld be on the streets tomorrow. Keep up with trends on MSN Lifestyle Try it! = --_2889696c-3135-4762-9bd3-fcc0e8e6e800_--