-----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.chauvet@aznetwork.fr
xmpp://christophe.chauvet@jabber.fr
AZNetwork http://www.aznetwork.fr/
**--------------------------------Oooo--------------------------** oooO ( )
( ) ) / \ ( (_/ \_)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
iD8DBQFGf66rMl/S4ZhUIzERAhe6AJ4uNRD618wof3MKa6qn7k5qjjZg1ACg4VEw
ezwCQQwpk299DhzZPh2EcT8=
=6DES
-----END PGP SIGNATURE-----