Re: Error starting pgAgent service on Windows 2008 R2 server

Поиск
Список
Период
Сортировка
От Dinesh Kumar
Тема Re: Error starting pgAgent service on Windows 2008 R2 server
Дата
Msg-id CAKWsr7jR+KuoLm=d=kfKAjx85kYROi4NAPQOcN6nu7bXO49Jkw@mail.gmail.com
обсуждение исходный текст
Ответ на Error starting pgAgent service on Windows 2008 R2 server  (David Blaymires <david.blaymires@instinctsystems.com.au>)
Список pgadmin-support
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

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


В списке pgadmin-support по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: [GENERAL] Lost database
Следующее
От: Dinesh Kumar
Дата:
Сообщение: Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3