X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C442D11F6782 for ; Thu, 30 Mar 2006 15:16:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19312-05 for ; Thu, 30 Mar 2006 15:16:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 6D11B11F66F3 for ; Thu, 30 Mar 2006 15:16:51 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 30 Mar 2006 19:16:51 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 30 Mar 2006 13:16:51 -0600 Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl From: Scott Marlowe To: lmyho Cc: Chris Travers , Tom Lane , pgsql-admin@postgresql.org In-Reply-To: <20060330173859.5287.qmail@web30812.mail.mud.yahoo.com> References: <20060330173859.5287.qmail@web30812.mail.mud.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1143746210.26940.29.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 30 Mar 2006 13:16:51 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.139 required=5 tests=[AWL=0.138, MANY_EXCLAMATIONS=0, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.139 X-Spam-Level: X-Archive-Number: 200603/387 X-Sequence-Number: 21144 On Thu, 2006-03-30 at 11:38, lmyho wrote: > > > > > > If I remember correctly, this is a problem with the debian startup > > script requiring trust for the postgres superuser, and was discussed > > sometime last year. I'll wander through the archives in a free moment > > and see if I can find it. > > Great Scott!! Thank you!! This system was just installed on Debian (2 days), and > the original pg_hba.conf file authen method was "ident sameuser" and appears not > allow it to be changed! > > Look forward to your information!! Thanks a lot!! Can't find the thread right now (my search-fu is not strong today) but I think this thread has covered all the basic points. Does anyone know if it is possible for the startup script to read the ~/.pgpass file of the postgres user on startup and use that if you absolutely have to have the main postgres user have a password on it in debian? My guess is that you could also just comment out the lines in the init script that are hanging, as the actual db startup should not require a password.