Обсуждение: pgAgent Crash on WinXP

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?

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.

Dave Page wrote:
>
> Please try v1.6.3 - there was a bug fixed that might well cause this
> crash.
>
> Regards, Dave.
>
Thanks Dave. I think that has fixed it.