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
