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 EABBC32B1E5 for ; Tue, 12 Oct 2004 04:55:05 +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 67430-10 for ; Tue, 12 Oct 2004 03:54:57 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 73E7732C1AB for ; Tue, 12 Oct 2004 04:54:56 +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 i9C3ssrg027629; Mon, 11 Oct 2004 23:54:54 -0400 (EDT) To: Ashley Maher Cc: pgsql-admin@postgresql.org Subject: Re: postmaster stopps In-reply-to: <416B4FA1.4010107@didymodesigns.com.au> References: <416B4FA1.4010107@didymodesigns.com.au> Comments: In-reply-to Ashley Maher message dated "Tue, 12 Oct 2004 13:29:37 +1000" Date: Mon, 11 Oct 2004 23:54:54 -0400 Message-ID: <27628.1097553294@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/165 X-Sequence-Number: 15158 Ashley Maher writes: > I installed postgresql-7.4.3 about three months ago. > Twice, with no known reason the postmaster has stopped. The postmaster is not known for "just stopping". There will certainly be some evidence either in the postmaster's log (if it aborted for some internal reason) or in the kernel log (if you got hit by the Linux OOM killer) or at worst in a core dump file left by the postmaster (though I really seriously doubt that one). Now it's entirely possible that you're starting the postmaster in a way that destroys the evidence. Check to see if you are sending postmaster stderr to /dev/null, and if so put it someplace more useful. Also make sure the postmaster is not being launched under "ulimit -c 0", and that it's being started in a directory that postgres is allowed to write (so that a core file can be created, if worst comes to worst). When you've got some evidence to look at, we'll be glad to help you interpret it, but there's no point in speculating without evidence. regards, tom lane