Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CED5D2E3BDF for ; Thu, 17 Jan 2008 19:49:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80543-01 for ; Thu, 17 Jan 2008 19:49:34 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 003892E3BEF for ; Thu, 17 Jan 2008 19:49:33 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m0HNnWLk017062; Thu, 17 Jan 2008 18:49:32 -0500 (EST) To: Mischa Sandberg cc: Stephen Frost , "Marc G. Fournier" , pgsql-hackers@postgresql.org Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal In-reply-to: <1200610323.478fdc131bb3a@webmail.telus.net> References: <1200501702.478e33c61b74e@webmail.telus.net> <4089.1200550374@sss.pgh.pa.us> <20080117143729.GR5031@tamriel.snowman.net> <1200610323.478fdc131bb3a@webmail.telus.net> Comments: In-reply-to Mischa Sandberg message dated "Thu, 17 Jan 2008 14:52:03 -0800" Date: Thu, 17 Jan 2008 18:49:32 -0500 Message-ID: <17061.1200613772@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/738 X-Sequence-Number: 113012 Mischa Sandberg writes: > I'm going to skip the kill(1,0) test and depend on nattch only, > with a function that PGSharedMemoryIsInUse() can also use. > (For a healthy server, nattch is never less than 2, right?) Oh, forgot to mention: healthy servers are not the point here. You should make the code keep its hands off any segment with nonzero nattch, because even one orphaned backend is enough to cause trouble. regards, tom lane