Skip site navigation (1) Skip section navigation (2)

Re: PgAgent Job Scehduler is NOT running

From: Abdul Rahman <abr_ora(at)yahoo(dot)com>
To: Vishal Arora <aroravishal22(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PgAgent Job Scehduler is NOT running
Date: 2008-11-28 10:11:34
Message-ID: 68882.57176.qm@web65708.mail.ac4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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(at)hotmail(dot)com>
To: abr_ora(at)yahoo(dot)com; pgsql-admin(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)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(at)yahoo(dot)com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22(at)hotmail(dot)com; pgsql-admin(at)postgresql(dot)org
CC: pgsql-general(at)postgresql(dot)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(at)hotmail(dot)com>
To: abr_ora(at)yahoo(dot)com; pgsql-admin(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)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(at)yahoo(dot)com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22(at)hotmail(dot)com; pgsql-admin(at)postgresql(dot)org
CC: pgsql-general(at)postgresql(dot)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(at)hotmail(dot)com>
To: abr_ora(at)yahoo(dot)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(at)yahoo(dot)com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22(at)hotmail(dot)com; pgsql-admin(at)postgresql(dot)org
CC: pgsql-general(at)postgresql(dot)org

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




----- Forwarded Message ----
From: Vishal Arora <aroravishal22(at)hotmail(dot)com>
To: abr_ora(at)yahoo(dot)com; pgsql-general(at)postgresql(dot)org
Cc: pgsql-admin(at)postgresql(dot)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(at)yahoo(dot)com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general(at)postgresql(dot)org
CC: pgsql-admin(at)postgresql(dot)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!


      

In response to

pgsql-admin by date

Next:From: lst_hoe02Date: 2008-11-28 10:32:10
Subject: Re: NUMA architecture and PostgreSQL
Previous:From: Julius TuskenisDate: 2008-11-28 07:57:06
Subject: postgresql client on WinCe

pgsql-general by date

Next:From: Daniel VeriteDate: 2008-11-28 10:23:45
Subject: Re: [NOOB] try tu put a number with pqexecprepare
Previous:From: elekisDate: 2008-11-28 09:28:54
Subject: [NOOB] try tu put a number with pqexecprepare

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group