Re: PgAgent fail to connect on Windows startup

Christophe Chauvet wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> 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 « 127.0.0.1 »
>     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:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgagent

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

Restart...

Regards Dave