Обсуждение: Error starting pgAgent service on Windows 2008 R2 server
Hi,
We've previously installed pgAgent successfully on Windows 2008 R2 servers but this latest server is doing our head in! When we try to start the service we get an error:
"Windows would not start the PostgreSQL Scheduling Agent - pgAgent service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion."
The PostgreSQL server is a 64 bit version: Version string PostgreSQL 9.1.10, compiled by Visual C++ build 1500, 64-bit. We installed pgAgent using Application Stackbuilder.
We've never seen this before and are stumped at this point. Can anyone point us at something to look at?
--
Regards,
David
David Blaymires
Managing Director/CEO
Phone +61 2 8115 8005
Fax +61 2 8115 8050
Mobile +61 (0)416 183 848
David.Blaymires@instinctsystems.com.au
http://www.instinctsystems.com.au
http://www.jobbag.com
Regards,
David
David Blaymires
Managing Director/CEO
Phone +61 2 8115 8005
Fax +61 2 8115 8050
Mobile +61 (0)416 183 848
David.Blaymires@instinctsystems.com.au
http://www.instinctsystems.com.au
http://www.jobbag.com
Hi David,
On Thu, Dec 5, 2013 at 2:03 PM, David Blaymires <david.blaymires@instinctsystems.com.au> wrote:
Hi,We've previously installed pgAgent successfully on Windows 2008 R2 servers but this latest server is doing our head in! When we try to start the service we get an error:"Windows would not start the PostgreSQL Scheduling Agent - pgAgent service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion."The PostgreSQL server is a 64 bit version: Version string PostgreSQL 9.1.10, compiled by Visual C++ build 1500, 64-bit. We installed pgAgent using Application Stackbuilder.We've never seen this before and are stumped at this point. Can anyone point us at something to look at?
Could you share the event log details when this service launch get failed. You can get these details from event log viewer.
Thanks,
Dinesh
--
Regards,
David
David Blaymires
Managing Director/CEO
Phone +61 2 8115 8005
Fax +61 2 8115 8050
Mobile +61 (0)416 183 848
David.Blaymires@instinctsystems.com.au
http://www.instinctsystems.com.au
http://www.jobbag.com
Hi David,
On Fri, Dec 6, 2013 at 2:57 AM, David Blaymires <david.blaymires@instinctsystems.com.au> wrote:
Hi Dinesh,Thanks for responding. This is all there is in the event viewer when we attempt to launch the pgAgent service: " A timeout was reached (30000 milliseconds) while waiting for the PostgreSQL Scheduling Agent - pgAgent service to connect."
Sorry for the delay. Unfortunately, this event log is not showing any useful information to me.
IIRC, when you start the pgAgent it will try to connect postgres. Could you check the pg_logs for any errors. And if possible, check the pgagent.log in your machine.
Regards,
Dinesh
Dinesh
The extended view of this event is :- System- Provider[ Name] Service Control Manager[ Guid] {555908d1-a6d7-4695-8e1e-26931d2012f4}[ EventSourceName] Service Control Manager- EventID 7009[ Qualifiers] 49152Version 0Level 2Task 0Opcode 0Keywords 0x8080000000000000- TimeCreated[ SystemTime] 2013-12-05T21:14:36.735803500ZEventRecordID 129338Correlation- Execution[ ProcessID] 632[ ThreadID] 10944Channel SystemComputer DMGEX.dmg.localSecurity- EventDataparam1 30000param2 PostgreSQL Scheduling Agent - pgAgent--Regards,DavidOn 5 Dec 2013, at 7:55 pm, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:Could you share the event log details when this service launch get failed. You can get these details from event log viewer.