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 4A65932A55C for ; Sun, 10 Oct 2004 20:29:54 +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 50068-02 for ; Sun, 10 Oct 2004 19:29:48 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8EE4A32A4A9 for ; Sun, 10 Oct 2004 20:29:48 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9AJTmRg012765; Sun, 10 Oct 2004 15:29:48 -0400 (EDT) To: "roger" Cc: pgsql-admin@postgresql.org Subject: Re: Postmaster terminated without any error message In-reply-to: <026a01c4ad6c$2374b1e0$6501a8c0@rlamry8o17vxdk> References: <026a01c4ad6c$2374b1e0$6501a8c0@rlamry8o17vxdk> Comments: In-reply-to "roger" message dated "Fri, 08 Oct 2004 15:22:22 -0400" Date: Sun, 10 Oct 2004 15:29:48 -0400 Message-ID: <12764.1097436588@sss.pgh.pa.us> From: Tom Lane 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/151 X-Sequence-Number: 15144 "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