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: 4679350A.30409@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

Responses

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-2014 The PostgreSQL Global Development Group