Skip site navigation (1) Skip section navigation (2)

Re: PgAgent fail to connect on Windows startup

From: Dave Page <dpage(at)postgresql(dot)org>
To: christophe(dot)chauvet(at)aznetwork(dot)fr
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: PgAgent fail to connect on Windows startup
Date: 2007-06-20 14:09:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Christophe Chauvet wrote:
> Hash: SHA1
> Hi dave
> i found a problem with PgAgent under Windows, the service start before "Postgresql Database Server
> 8.2" and i have this message in Event Viewer
> Couldn't create connection: n'a pas pu se connecter au serveur : Connection refused (0x0000274D/10061)
> 	Le serveur est-il actif sur l'hôte « »
> 	et accepte-t-il les connexions TCP/IP sur le port 5432 ?
> If i restart PgAgent manually, it works.
> When i open the "PgAgent Scheduling Agent" properties dialog, under Depends Tab, PgAgent Service
> don't have any depends
> How can i resolved this problem ?

This is untested, but in theory...

In regedit, assuming your pgAgent service ID is pgagent, add a 
REG_MULTI_SZ value called DependOnService under:


Edit the value, and add the service ID of your local PostgreSQL 
installation, eg. pgsql-8.2


Regards Dave

In response to


pgadmin-support by date

Next:From: Christophe ChauvetDate: 2007-06-20 15:20:22
Subject: Re: PgAgent fail to connect on Windows startup
Previous:From: Christophe ChauvetDate: 2007-06-20 13:38:01
Subject: PgAgent fail to connect on Windows startup

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group