Re: BUG #18428: Connection broken but DB service still alive.

Hi Tom,

It there a log path can record the shutdown signal is from where?
Because our postgresql server just provide for one web application to use.
And our test environment never happen this issue with same web application
& DB version.

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 於 2024年4月12日 週五 下午9:38寫道：

> PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> > 2024-04-06 13:54:53.868 CST [4840] LOG: received fast shutdown request
>
> Something is sending your postmaster a shutdown signal (SIGINT).
> You need to figure out how that is happening.
>
> In the Windows world I think the most likely theory is that some
> script is mistakenly issuing "pg_ctl stop"; the signal mechanism
> we use on that platform doesn't map onto anything else people would
> commonly do. But that's a guess. There's no hard evidence about
> the signal source here.
>
> regards, tom lane
>

--
*Thank you & Best Regards*

*Harry Lu*

*______________________________________*

*Linktech Inc.*

*220 新北市板橋區三民路2段37號7樓之2*
*Phone:+886-2-2959-9166#160 <+886%202%207703%201979>、**+886-2-7752-7658#160
<+886%202%207752%207658>*

*E-mail: harry(at)linktech(dot)com(dot)tw <harry(at)linktech(dot)com(dot)tw>**Web:
www.linktech.com.tw
<http://www.linktech.com.tw/>*