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 1A6FD53777 for ; Wed, 20 Apr 2005 12:08:34 -0300 (ADT) 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 84698-07 for ; Wed, 20 Apr 2005 15:08:24 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 181ED5360E for ; Wed, 20 Apr 2005 12:08:23 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j3KF8HwR032476 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 20 Apr 2005 09:08:19 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j3KF8HMG075341; Wed, 20 Apr 2005 09:08:17 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j3KF8HP4075340; Wed, 20 Apr 2005 09:08:17 -0600 (MDT) (envelope-from mfuhr) Date: Wed, 20 Apr 2005 09:08:17 -0600 From: Michael Fuhr To: Bobb Shields Cc: pgsql-admin@postgresql.org Subject: Re: Troubleshooting Postgres7.4 Message-ID: <20050420150817.GA75226@winnie.fuhr.org> References: <46a1632105041911115fafc703@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46a1632105041911115fafc703@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/284 X-Sequence-Number: 17297 On Tue, Apr 19, 2005 at 02:11:47PM -0400, Bobb Shields wrote: > > I'm running 7.4, and I recently did a few upgrades, which seem to have > broken it. Could you expand on "seem to have broken it"? What are you doing and what unexpected behavior or error messages are you seeing? > I believe that all of them were php updates. What exactly did you change? The version of PHP? Application code written in PHP? Something else, like settings in postgresql.conf? > Anywho, my service configuration shows that postmaster is stopped. I > can't find an instance of it in my system monitor. > > Can you help me to figure out if its still running, and if its not, why it > won't start like it should? You could use ps from a shell prompt to verify whether the postmaster is running. For example, "ps ax | grep postmaster" should work on your system (you said you were using Linux). Try to start the postmaster from the shell and see what happens. If it doesn't start but you see nothing on the screen, then look through postgresql.conf and the PostgreSQL startup script to see where log messages are going, then look through those messages to see what's happening. As I recall, some PostgreSQL packages for Linux redirect the postmaster's output to /dev/null -- if this is the case on your system, then I'd suggest changing that so you can see startup errors. -- Michael Fuhr http://www.fuhr.org/~mfuhr/