Re: PgAgent fail to connect on Windows startup

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Dave

The only solution i see to beat this problem is to add a delay before connect to the PostgreSQL
Database with a new option (for exemple -d).

options
- -d <delay> Add delay (in second) before connect to the database.

pgAgent INSTALL pgAgent -d 10 -u postgres ....

What do you think about this ?

Regards

Christophe Chauvet.

Christophe Chauvet a écrit :
> I have tested your solution, it work (in theory) :), but i have this message in the event viewer,
>
> "Couldn't create connection: FATAL: the database system is starting up"
>
> How can we resolved this statement ?
>
> Regards,
>
> Christophe Chauvet
>
> Dave Page a écrit :
>
>> 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

- ---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

- --

Cordialement.

Christophe Chauvet.
- --
\|///
\ - - //
( @ @ )
**-------------------------oooO-(_)-Oooo------------------------**
Christophe Chauvet mailto://christophe(dot)chauvet(at)aznetwork(dot)fr
xmpp://christophe(dot)chauvet(at)jabber(dot)fr

AZNetwork http://www.aznetwork.fr/
**--------------------------------Oooo--------------------------**
oooO ( )
( ) ) /
\ ( (_/
\_)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)

iD8DBQFGf66rMl/S4ZhUIzERAhe6AJ4uNRD618wof3MKa6qn7k5qjjZg1ACg4VEw
ezwCQQwpk299DhzZPh2EcT8=
=6DES
-----END PGP SIGNATURE-----