Re: pgAgent: Log connection error message and initial connection - Mailing list pgadmin-hackers

From Dave Page
Subject Re: pgAgent: Log connection error message and initial connection
Date
Msg-id 937d27e10902100909y3e0dd877o2fb0b03b59a50905@mail.gmail.com
Whole thread Raw
In response to Re: pgAgent: Log connection error message and initial connection  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-hackers
On Fri, Feb 6, 2009 at 2:33 PM, Ashesh Vashi
<ashesh.vashi@enterprisedb.com> wrote:
> Hi Dave,
>
> - If the initial connection attempt fails, it will loop, and
>   retry a few times at the speed of the normal timing loop
>   before giving up.
>
> Hmm, I don't see any of the service code I expected to see for
> Windows. At the moment when the service starts we start MainLoop() and
> immediately tell the SCM that the service state is 'running'. What we
> should do, is tell the SCM that the service is starting until the
> primary connection is successful, and only then tell the SCM that
> we're running. That way, the service will refuse to start if the
> connection cannot be made, rather than starting and then stopping
> again. It'll also mean that when starting the service manually, the
> progress bar will be shown until the connection is established and we
> know everything is good.
>
> That's the code I mentioned I'd worked on in pg_ctl - in particular
> look at the do_checkpoint related stuff in
> test_postmaster_connection() which is how we tell the SCM that we're
> still trying to startup.
>
> Please find the updated patch for that.

Thanks - patch applied with some minor cosmetic tweaking, and removal
of the START_SUSPENDED stuff that we never used anyway.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

pgadmin-hackers by date:

Previous
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r7584 - in trunk/pgagent: . include
Next
From: Guillaume Lelarge
Date:
Subject: Re: Server Status window work