Re: Error starting pgAgent service on Windows 2008 R2 server

Hi David,

On Fri, Dec 6, 2013 at 2:57 AM, David Blaymires <
david(dot)blaymires(at)instinctsystems(dot)com(dot)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

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] 49152
> Version 0
> Level 2
> Task 0
> Opcode 0
> Keywords 0x8080000000000000
> - TimeCreated
> [ SystemTime] 2013-12-05T21:14:36.735803500Z
> EventRecordID 129338
> Correlation
> - Execution
> [ ProcessID] 632
> [ ThreadID] 10944
> Channel System
> Computer DMGEX.dmg.local
> Security
> - EventData
> param1 30000
> param2 PostgreSQL Scheduling Agent - pgAgent
>
>
> --
> Regards,
>
> David
>
> On 5 Dec 2013, at 7:55 pm, Dinesh Kumar <dinesh(dot)kumar(at)enterprisedb(dot)com>
> wrote:
>
> Could you share the event log details when this service launch get failed.
> You can get these details from event log viewer.
>
>
>