Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4FC639F9B3A for ; Fri, 2 Feb 2007 17:05:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 00631-08 for ; Fri, 2 Feb 2007 17:05:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 619C09FB28E for ; Fri, 2 Feb 2007 17:05:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l12L4utG024129; Fri, 2 Feb 2007 16:04:56 -0500 (EST) To: "Joshua D. Drake" cc: Shane Ambler , Shoaib Mir , Manish Pillai , pgsql-admin@postgresql.org Subject: Re: Postgres is not starting or stopping In-reply-to: <45C3A2AF.8080606@commandprompt.com> References: <878936.26029.qm@web52313.mail.yahoo.com> <45C3A015.5080808@007Marketing.com> <45C3A2AF.8080606@commandprompt.com> Comments: In-reply-to "Joshua D. Drake" message dated "Fri, 02 Feb 2007 12:44:31 -0800" Date: Fri, 02 Feb 2007 16:04:56 -0500 Message-ID: <24128.1170450296@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/30 X-Sequence-Number: 24495 "Joshua D. Drake" writes: > Shane Ambler wrote: >> Your prob may be knowing where the log is. By default you will find it >> in your data directory along with postgresql.conf and it will be called >> serverlog > likely /var/log/postgresql > What linux is this? There are enough different initscripts out there that the only way to be sure is to look at the initscript and see what it's doing with the postmaster's stderr output. It's not too unlikely that it's sending it to /dev/null, in which case your only hope of finding out what's going wrong is to change the script. Or you could try launching the postmaster manually as someone recommended upthread, but that may well fail to show the problem. regards, tom lane