SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-24-2008, 06:12 PM
| ||||
| ||||
 Re: Server Crash > From: Scott Marlowe [mailto:scott.marlowe@gmail.com] >> Kill -9 is the "shoot it in the head" signal. It is not >> generated by postgresql in normal operation. It can be >> generated by "pg_ctl -m immediate stop" . At least I think >> that's what signal it sends. Just for the archives: Postgres never generates kill -9 at all. (Immediate stop uses SIGQUIT, instead.) When you see that in the log, you can be sure it was a manual action or the OOM killer. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin      |
|
04-24-2008, 06:12 PM
| |||
| |||
| Re: Server Crash On Tue, Apr 22, 2008 at 10:06 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > > From: Scott Marlowe [mailto:scott.marlowe@gmail.com] > > >> Kill -9 is the "shoot it in the head" signal. It is not > >> generated by postgresql in normal operation. It can be > >> generated by "pg_ctl -m immediate stop" . At least I think > >> that's what signal it sends. > > Just for the archives: Postgres never generates kill -9 at all. > (Immediate stop uses SIGQUIT, instead.) When you see that in > the log, you can be sure it was a manual action or the OOM killer. Thanks. Just wondering, what's the difference in behavior from pgsql's perspective from sigquit and siqkill? Is sigkill more dangerous than sigquit? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin |
|
04-24-2008, 06:12 PM
| ||||
| ||||
| Re: Server Crash "Scott Marlowe" <scott.marlowe@gmail.com> writes: > Thanks. Just wondering, what's the difference in behavior from > pgsql's perspective from sigquit and siqkill? Is sigkill more > dangerous than sigquit? Yes it is, because sigkill can't be trapped --- it causes instant process death with no chance to clean up. Not that we have backends do a lot of cleanup after sigquit either, but at least the option exists. The real difference is in the postmaster: kill -9 on the postmaster is a seriously bad idea, because it gets no chance to shut down its children. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin |
Linear Mode
