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
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.
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.
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
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
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
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
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
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]>;
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
Deal All,
I have set postgresql.conf for autovacuum and need to know weather the process
is running/working or not.
Regards,
Avdul Rehman.
12 matches
Mail list logo