X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C7A7932A133 for ; Sun, 10 Oct 2004 23:02:16 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85788-02 for ; Sun, 10 Oct 2004 22:02:09 +0000 (GMT) Received: from tagalder.propagation.net (tagalder.propagation.net [209.164.74.155]) by svr1.postgresql.org (Postfix) with ESMTP id 6437D329F57 for ; Sun, 10 Oct 2004 23:02:09 +0100 (BST) Received: from rlamry8o17vxdk (CPE00045a2a1b48-CM400026162778.cpe.net.cable.rogers.com [65.48.246.149]) by tagalder.propagation.net (8.11.6/8.11.6) with SMTP id i9AM1oh22935; Sun, 10 Oct 2004 16:01:51 -0600 Message-ID: <03b501c4af14$acbcd640$6501a8c0@rlamry8o17vxdk> From: "roger" To: "Tom Lane" Cc: References: <026a01c4ad6c$2374b1e0$6501a8c0@rlamry8o17vxdk> <12764.1097436588@sss.pgh.pa.us> Subject: Re: Postmaster terminated without any error message Date: Sun, 10 Oct 2004 18:01:18 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/156 X-Sequence-Number: 15149 Thanks for your information. I couldn't find the "ulimit" setting in postgresql.conf. Where can I find it? I use the default settings in pgsql. Thanks. Roger Lam ----- Original Message ----- From: "Tom Lane" To: "roger" Cc: Sent: Sunday, October 10, 2004 3:29 PM Subject: Re: [ADMIN] Postmaster terminated without any error message > "roger" writes: > > We have Postgresql 7.2 under Redhat 7.2. Postmaster can be started and we c= > > an use it without problem. However postmaster will terminate abnormally aft= > > er 1 or 2 hours and leave no error messages. > > I suspect you are starting the postmaster under resource constraints > (check "ulimit" settings) or else the postmaster is getting hit by the > kernel's infamous "out-of-memory killer" (google for "OOM kill" for more > info). > > In recent Linux kernels you can prevent OOM kills by adjusting the > kernel's memory allocation parameters, but RH 7.2 may be too old to give > you that control. > > regards, tom lane