Hi,
I have recently started using the pgAgent and I am having some issues
with the agent service crashing.
The job that I am running has two steps:
1. A vacuum.
2. Backup, which executes the following
"c:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p
5432 -U postgres -F p -b -v --encoding=SQL_ASCII -f
"d:\hq\backup\daily.backup" "hq"
Both steps appear to work, and the backup is created, and according to
pgAdminIII, both steps are complete. However the status of the overall
job is still "Running" according to pgAdmin, and the service has crashed.
This is the error that I get in the application log:
Faulting application pgAgent.exe, version 1.6.2.99, faulting module
pgAgent.exe, version 1.6.2.99, fault address 0x000050fd.
Any Ideas?