X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6EC6A9FA12F for ; Mon, 5 Jun 2006 15:49:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 64211-03 for ; Mon, 5 Jun 2006 15:49:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 722D49FA5B5 for ; Mon, 5 Jun 2006 15:48:59 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 5 Jun 2006 18:48:51 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 05 Jun 2006 13:48:51 -0500 Subject: Re: postgres dying From: Scott Marlowe To: Callis Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1149533331.25526.190.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 05 Jun 2006 13:48:51 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/19 X-Sequence-Number: 21981 On Mon, 2006-06-05 at 12:03, Callis wrote: > Hi all, > > Please pardon me if it sound naive or its been answered. > I am running freeradius with postgresql for VOIP with > Cisco gateways. But my server keeps dying and after tuning > the SHMMX and number of connections and all that i still > get the same results. > > Any form of help will be greatly appreciated. > > Thank you. Most of the time this happens, PostgreSQL isn't dying so much as being euthanized by the OS for some reason. Perhaps you're hitting the oom killer in the linux kernel, or you're running it under a ulimit that results in it being killed. If it is dying, is there anything in the postgresql logs showing why it died? Generally speaking, if the database starts up, the shmmax settings and such are fine, as they are not particularly dynamic in their allocation.