|From:||"Higuchi, Daisuke" <higuchi(dot)daisuke(at)jp(dot)fujitsu(dot)com>|
|To:||'Laurenz Albe' <laurenz(dot)albe(at)cybertec(dot)at>, "Sakai, Teppei" <sakai(dot)teppei(at)jp(dot)fujitsu(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>|
|Subject:||RE: Problem during Windows service start|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
This thread is inactive, but I want to solve this problem.
I think this problem rarely occurs in 10 or later version because of commit . Because "pg_ctl start -w" wait for only PID file creation. It means that timeout is not occurred even if crash recovery takes a lot of times.
However, 9.6 or earlier still wait for long time recovery complete.
> How do you propose to fix it?
I think there are two solutions.
One solution is that status of Windows Service should be changed to "SERVICE_RUNNING" even if timeout is occurred because of long time recovery. I attached the patch of this solution.
Another solution is to backport commit  to 9.6 or earlier version. However this fix change the content of PID file, so incompatible change, I think.
I would appreciate it if you give any comments.
|Next Message||Michael Paquier||2019-01-09 05:40:23||Re: Problem during Windows service start|
|Previous Message||Haribabu Kommi||2019-01-09 04:56:20||Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query|