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

From Higuchi, Daisuke
Subject RE: Problem during Windows service start
Date
Msg-id 1803D792815FC24D871C00D17AE95905DF9ADE@g01jpexmbkw24
Whole thread Raw
In response to Re: Problem during Windows service start  (Ramanarayana <raam.soft@gmail.com>)
List pgsql-hackers
Hi, 

+           case POSTMASTER_STILL_STARTING:
+               write_eventlog(EVENTLOG_ERROR_TYPE, _("Timed out waiting for server startup\n"));
+               pgwin32_SetServiceStatus(SERVICE_START_PENDING);
+               return;

Could this patch solve first post's problem [1] ?
I think no one could change the service status to SERVICE_RUNNING even if the server has been started properly after
timeoutis occurred. 
 

In 9.6 or earlier, the main use case where the problem is occurred is when timeout is occured because of long time
recovery.Even if recovery takes a lot of time and timeout is ocurred, recovery continues in background. In this case, I
wantto set the status to SERVICE_RUNNING after recovery is completed. 
 

In 10 or later, I understand wait_for_postmaster does not wait until recovery is completed, so I think this problem
rarelyoccurs in PG 10 or later.
 

[1] https://www.postgresql.org/message-id/99C4246E73ED1B478BBB9671718426203E37F485@G01JPEXMBKW03

Regards, 
Daisuke, Higuchi


pgsql-hackers by date:

Previous
From: Konstantin Knizhnik
Date:
Subject: Re: Zedstore - compressed in-core columnar storage
Next
From: Chris Travers
Date:
Subject: Re: Berserk Autovacuum (let's save next Mandrill)