MIME-Version: 1.0
From: Josh Kupershmidt <schmiddy@gmail.com>
Date: Fri, 29 Jun 2012 20:10:40 -0700
Message-ID: 
 <CAK3UJRHHVHSLewwwXzKcvhKoXagxR07j=2U4P9hGqPmA=oJ1Kg@mail.gmail.com>
Subject: Out of date advice about SIGTERM'ing backends
To: pgsql-docs <pgsql-docs@postgresql.org>
Content-Type: multipart/mixed; boundary=e89a8fb1eef2113b7f04c3a7eaf8

--e89a8fb1eef2113b7f04c3a7eaf8
Content-Type: text/plain; charset=ISO-8859-1

Hi all,

In the "Notes" section[0] of the postgres command's page, this advice is given:

| The postgres server uses SIGTERM to tell subordinate server
| processes to quit normally and SIGQUIT to terminate without
| the normal cleanup. These signals should not be used by users.

I think now that we've added pg_terminate_backend() and made it
callable by non-superusers, we should relax the caveat against using
SIGTERM against backends. The warning to stay away from using SIGQUIT
seems fine as-is. Patch attached.

Josh

[0] http://www.postgresql.org/docs/9.2/static/app-postgres.html#AEN87192

--e89a8fb1eef2113b7f04c3a7eaf8
Content-Type: application/octet-stream; name="backends_sigterm.diff"
Content-Disposition: attachment; filename="backends_sigterm.diff"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_h4245d140

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvcG9zdGdyZXMtcmVmLnNnbWwgYi9kb2Mvc3Jj
L3NnbWwvcmVmL3Bvc3RncmVzLXJlZi5zZ21sCm5ldyBmaWxlIG1vZGUgMTAwNjQ0CmluZGV4IDRl
NWNkMDIuLmExZDAxNGQKKioqIGEvZG9jL3NyYy9zZ21sL3JlZi9wb3N0Z3Jlcy1yZWYuc2dtbAot
LS0gYi9kb2Mvc3JjL3NnbWwvcmVmL3Bvc3RncmVzLXJlZi5zZ21sCioqKioqKioqKioqKioqKiBQ
b3N0Z3JlU1FMIGRvY3VtZW50YXRpb24KKioqIDcyNiw3MzkgKioqKgogIAogICAgPHBhcmE+CiAg
ICAgVG8gY2FuY2VsIGEgcnVubmluZyBxdWVyeSwgc2VuZCB0aGUgPGxpdGVyYWw+U0lHSU5UPC9s
aXRlcmFsPiBzaWduYWwKISAgICB0byB0aGUgcHJvY2VzcyBydW5uaW5nIHRoYXQgY29tbWFuZC4K
ICAgIDwvcGFyYT4KICAKICAgIDxwYXJhPgohICAgIFRoZSA8Y29tbWFuZD5wb3N0Z3JlczwvY29t
bWFuZD4gc2VydmVyIHVzZXMgPGxpdGVyYWw+U0lHVEVSTTwvbGl0ZXJhbD4KISAgICB0byB0ZWxs
IHN1Ym9yZGluYXRlIHNlcnZlciBwcm9jZXNzZXMgdG8gcXVpdCBub3JtYWxseSBhbmQKISAgICA8
bGl0ZXJhbD5TSUdRVUlUPC9saXRlcmFsPiB0byB0ZXJtaW5hdGUgd2l0aG91dCB0aGUgbm9ybWFs
IGNsZWFudXAuCiEgICAgVGhlc2Ugc2lnbmFscyA8ZW1waGFzaXM+c2hvdWxkIG5vdDwvZW1waGFz
aXM+IGJlIHVzZWQgYnkgdXNlcnMuICBJdAogICAgIGlzIGFsc28gdW53aXNlIHRvIHNlbmQgPGxp
dGVyYWw+U0lHS0lMTDwvbGl0ZXJhbD4gdG8gYSBzZXJ2ZXIKICAgICBwcm9jZXNzICZtZGFzaDsg
dGhlIG1haW4gPGNvbW1hbmQ+cG9zdGdyZXM8L2NvbW1hbmQ+IHByb2Nlc3Mgd2lsbAogICAgIGlu
dGVycHJldCB0aGlzIGFzIGEgY3Jhc2ggYW5kIHdpbGwgZm9yY2UgYWxsIHRoZSBzaWJsaW5nIHBy
b2Nlc3NlcwotLS0gNzI2LDc0MyAtLS0tCiAgCiAgICA8cGFyYT4KICAgICBUbyBjYW5jZWwgYSBy
dW5uaW5nIHF1ZXJ5LCBzZW5kIHRoZSA8bGl0ZXJhbD5TSUdJTlQ8L2xpdGVyYWw+IHNpZ25hbAoh
ICAgIHRvIHRoZSBwcm9jZXNzIHJ1bm5pbmcgdGhhdCBjb21tYW5kLiBUbyB0ZXJtaW5hdGUgYSBi
YWNrZW5kIHByb2Nlc3MKISAgICBjbGVhbmx5LCBzZW5kIDxsaXRlcmFsPlNJR1RFUk08L2xpdGVy
YWw+IHRvIHRoYXQgcHJvY2Vzcy4gU2VlCiEgICAgYWxzbyA8ZnVuY3Rpb24+cGdfY2FuY2VsX2Jh
Y2tlbmQ8Lz4gYW5kIDxmdW5jdGlvbj5wZ190ZXJtaW5hdGVfYmFja2VuZDwvPgohICAgIGluIDx4
cmVmIGxpbmtlbmQ9ImZ1bmN0aW9ucy1hZG1pbi1zaWduYWwiPiBmb3IgdGhlIFNRTC1jYWxsYWJs
ZSBlcXVpdmFsZW50cwohICAgIG9mIHRoZXNlIHR3byBhY3Rpb25zLgogICAgPC9wYXJhPgogIAog
ICAgPHBhcmE+CiEgICAgVGhlIDxjb21tYW5kPnBvc3RncmVzPC9jb21tYW5kPiBzZXJ2ZXIgdXNl
cyA8bGl0ZXJhbD5TSUdRVUlUPC9saXRlcmFsPgohICAgIHRvIHRlbGwgc3Vib3JkaW5hdGUgc2Vy
dmVyIHByb2Nlc3NlcyB0byB0ZXJtaW5hdGUgd2l0aG91dCBub3JtYWwKISAgICBjbGVhbnVwLgoh
ICAgIFRoaXMgc2lnbmFsIDxlbXBoYXNpcz5zaG91bGQgbm90PC9lbXBoYXNpcz4gYmUgdXNlZCBi
eSB1c2Vycy4gIEl0CiAgICAgaXMgYWxzbyB1bndpc2UgdG8gc2VuZCA8bGl0ZXJhbD5TSUdLSUxM
PC9saXRlcmFsPiB0byBhIHNlcnZlcgogICAgIHByb2Nlc3MgJm1kYXNoOyB0aGUgbWFpbiA8Y29t
bWFuZD5wb3N0Z3JlczwvY29tbWFuZD4gcHJvY2VzcyB3aWxsCiAgICAgaW50ZXJwcmV0IHRoaXMg
YXMgYSBjcmFzaCBhbmQgd2lsbCBmb3JjZSBhbGwgdGhlIHNpYmxpbmcgcHJvY2Vzc2VzCg==
--e89a8fb1eef2113b7f04c3a7eaf8--