| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Anoo Sivadasan Pillai" <aspillai(at)in(dot)rm(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: FW: max_connections and shared_buffers |
| Date: | 2007-09-03 13:42:21 |
| Message-ID: | 7894.1188826941@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> Not sure with Windows. I'm strictly a unix type of guy. I'm guessing
> that Windows is detecting too many connections / out of memory and
> shutting down the service.
The whole thing is pretty strange. "received fast shutdown request"
means that the postmaster got SIGINT --- a moment's look at the code
proves there is no other possibility. Now what sent it SIGINT?
AFAICS there are only two possible paths: "pg_ctl stop -m fast" or
this little bit of code in win32/signal.c:
/* Console control handler will execute on a thread created
by the OS at the time of invocation */
static BOOL WINAPI
pg_console_handler(DWORD dwCtrlType)
{
if (dwCtrlType == CTRL_C_EVENT ||
dwCtrlType == CTRL_BREAK_EVENT ||
dwCtrlType == CTRL_CLOSE_EVENT ||
dwCtrlType == CTRL_SHUTDOWN_EVENT)
{
pg_queue_signal(SIGINT);
return TRUE;
}
return FALSE;
}
Can any Windows hackers speculate on causes of this?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2007-09-03 18:54:51 | Re: transaction ID query |
| Previous Message | Scott Marlowe | 2007-09-03 07:28:11 | Re: FW: max_connections and shared_buffers |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-09-03 13:47:39 | Re: tsearch filenames unlikes special symbols and numbers |
| Previous Message | Magnus Hagander | 2007-09-03 13:34:23 | Re: tsearch filenames unlikes special symbols and numbers |