Re: PgAgent fail to connect on Windows startup

[Dave Page <dpage(at)postgresql(dot)org>]

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