Howard Cole wrote:
> 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.
Please try v1.6.3 - there was a bug fixed that might well cause this crash.
Regards, Dave.