[ADMIN] kindly unsubscribe me

2008-09-25 Thread Abdul Rahman

[ADMIN] Scheduling backup via PgAgent

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

Re: [ADMIN] Scheduling backup via PgAgent

2008-11-19 Thread Abdul Rahman
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.

[ADMIN] PgAgent Job Scehduler is NOT running

2008-11-23 Thread Abdul Rahman
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.

Re: [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]; [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Tuesday, November 25, 2008 11:47:33

Re: [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]; [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Tuesday, November 25, 2008 11:47:33 A

Re: [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: [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: [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]; pgsql-admin@postgresql.org Cc: [EMAIL PROTECTED] Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Re: [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]>;

Re: [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

[ADMIN] autovacuum daemon

2009-01-21 Thread Abdul Rahman
Deal All, I have set postgresql.conf for autovacuum and need to know weather the process is running/working or not. Regards, Avdul Rehman.