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
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 220.127.116.11, faulting module
pgAgent.exe, version 18.104.22.168, fault address 0x000050fd.
pgsql-general by date
|Next:||From: Dave Page||Date: 2007-03-29 12:24:51|
|Subject: Re: pgAgent Crash on WinXP|
|Previous:||From: Richard Huxton||Date: 2007-03-29 12:10:22|
|Subject: Re: Reading from a text file, or unix console screen|