Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-28 Thread Vishal Arora
Its located in Application Data folder. Date: Thu, 27 Nov 2008 21:12:23 -0800From: [EMAIL PROTECTED]: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]: pgsql-general@postgresql.org I searched but didn't find any pgpass.conf file. From: Vishal Arora

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-28 Thread Abdul Rahman
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 A

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-27 Thread Abdul Rahman
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 <[EMAIL PROTECTED]> To: Vishal Arora <[EMAIL PROTECTED]>; [EMAIL PROTECTED]

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-27 Thread Abdul Rahman
I searched but didn't find any pgpass.conf file. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT runni

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-27 Thread Vishal Arora
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 -0800From: [EMAIL PROTECTED]: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]: pgsql-general@postgresql.org Thanks Vishal,I followe

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-26 Thread Abdul Rahman
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 bot

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-26 Thread Vishal Arora
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 -0800From: [EMAIL PROTECTED]: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]: pgsql-general@postgresql.org

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-25 Thread Abdul Rahman
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 <[EMAIL PROTECTED]> To: [E

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-24 Thread Abdul Rahman
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. - Forwarded Message From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-24 Thread Abdul Rahman
No error message appeared. Because statistics is available for the job. It reflects that it is not running. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:

Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-24 Thread Vishal Arora
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 -0800From: [EMAIL PROTECTED]: [ADMIN] PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]: [EMAIL PROTECTED] Dear all,I installed PgAgent and started i