Re: Problem during Windows service start - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Problem during Windows service start
Date
Msg-id 1533226107.15730.4.camel@cybertec.at
Whole thread Raw
In response to Problem during Windows service start  ("Sakai, Teppei" <sakai.teppei@jp.fujitsu.com>)
Responses RE: Problem during Windows service start
List pgsql-hackers
Sakai, Teppei wrote:
> This is my first posting to the mailing list.
> 
> Currently our customer uses PostgreSQL 9.5 and hits problem during Windows service start.
> The Windows service status of the instance is different from actual status.
> 
> We got the following situation.
> 1. Register service with 'pg_ctl register -N "PostgreSQL" -U postgres -P xxxx -D D:\data\inst1 -w'
> 2. Start the instance from the Windows service screen.
> 3. After 60 seconds, the startup process fails with a timeout.
>    Because crash recovery takes a lot of times.
> 
> Then, the service status of the instance become "STOPPED",
> but the instance was running.
> It cannot be stopped from the Windows service screen (it can be stopped only with pg_ctl).
> 
> PostgreSQL version : 9.5.12
> Operating system : Windows Server 2012 R2
> 
> I think this is a bug.
> I think it has not been fixed in the latest version, is my understanding correct?
> If it is correct, I will fix it.

I agree that this is not nice.

How do you propose to fix it?

Yours,
Laurenz Albe


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Ideas for a relcache test mode about missing invalidations
Next
From: Vladimir Sitnikov
Date:
Subject: Re: Stored procedures and out parameters