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 3B43111F660A for ; Thu, 30 Mar 2006 01:53:43 -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 33276-01 for ; Thu, 30 Mar 2006 01:53:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.travelamericas.com (unknown [206.130.134.147]) by postgresql.org (Postfix) with SMTP id 63C3311F65B6 for ; Thu, 30 Mar 2006 01:53:26 -0400 (AST) Received: (qmail 13567 invoked from network); 30 Mar 2006 05:53:23 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 30 Mar 2006 05:53:23 -0000 Message-ID: <442B7252.7050705@metatrontech.com> Date: Wed, 29 Mar 2006 21:53:22 -0800 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lmyho CC: Chris Travers , pgsql-admin@postgresql.org Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! References: <20060330052337.57976.qmail@web30809.mail.mud.yahoo.com> In-Reply-To: <20060330052337.57976.qmail@web30809.mail.mud.yahoo.com> Content-Type: multipart/mixed; boundary="------------080806080606020304070709" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.111 required=5 tests=[AWL=0.111, MANY_EXCLAMATIONS=0] X-Spam-Score: 0.111 X-Spam-Level: X-Archive-Number: 200603/366 X-Sequence-Number: 21123 This is a multi-part message in MIME format. --------------080806080606020304070709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit lmyho wrote: >>>Things to check when PostgreSQL doesn't seem to start: >>>... >>>In your case, if PostgreSQL is hanging, I would suspect that the problem >>>is likely to be with something else. Hopefully there would be info in >>>the serverlog that would help. >>> >>> >>> >>> >>What I'm guessing is that the server started just fine, but the Debian >>initscript is trying to connect to it (to verify that it started) and >>that's failing because of the change in authentication options. You >>might have to remove the -w option from pg_ctl, or some such, in the >>script ... or else fix things so that root is allowed to connect ... >> >> >> >> >To fix this you will ideally want to be familiar enough with the init >script system to be able to edit it. In most distros (never used >Debian) it is in /etc/init.d/ and is named something like postgresql. >Look in there. If you can't figure it out, you can post it in the email. > > >I will do to check about it. But I am not sure if I can fix something as I am new to Debian too,:( just installed it last week, one of the purpose is to use postgresql. Unfortunately, only a beginner at this time for both systems.:( > > It is usually a simple shell script that starts/stops PostgreSQL. At least the ones that come with the PostgreSQL source are pretty easy to understand. > >I may post back the info of the init file, I know there is postgresql in the init.d directory. And hope to get your further help from that. > > That would be the file. Best Wishes, Chris Travers Metatron Technology Consulting > > > --------------080806080606020304070709 Content-Type: text/x-vcard; charset=utf-8; name="chris.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="chris.vcf" begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com tel;work:509-888-0220 tel;cell:509-630-7794 x-mozilla-html:FALSE version:2.1 end:vcard --------------080806080606020304070709--