Thread: 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.