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 385F211F66FA for ; Thu, 30 Mar 2006 13:39:04 -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 18690-06 for ; Thu, 30 Mar 2006 13:39:02 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web30812.mail.mud.yahoo.com (web30812.mail.mud.yahoo.com [68.142.201.138]) by postgresql.org (Postfix) with SMTP id 8D89E11F66C5 for ; Thu, 30 Mar 2006 13:39:00 -0400 (AST) Received: (qmail 5289 invoked by uid 60001); 30 Mar 2006 17:38:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Kywa//b5H8FP5CIIs3IgwyNk5KPspJ4UMLMh2our4awZma+ixNYVhoQ3523cfgTQkt9plZ0uYAU+FRuekCwbtWNZdZv3/u8t8EhDUVWdH8PajfZB8fDJXulNCr4tAiw3Kf+DgH+6rfY9Xsdgtn7fAt6ueJCXaepbYR2M0PJEbeA= ; Message-ID: <20060330173859.5287.qmail@web30812.mail.mud.yahoo.com> Received: from [67.175.142.230] by web30812.mail.mud.yahoo.com via HTTP; Thu, 30 Mar 2006 09:38:59 PST Date: Thu, 30 Mar 2006 09:38:59 -0800 (PST) From: lmyho Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! To: Scott Marlowe , Chris Travers Cc: lmyho , Tom Lane , pgsql-admin@postgresql.org In-Reply-To: <1143738779.26940.24.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.255 required=5 tests=[AWL=-0.103, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, MANY_EXCLAMATIONS=0] X-Spam-Score: 1.255 X-Spam-Level: * X-Archive-Number: 200603/386 X-Sequence-Number: 21143 > > > > > > > > Interesting.... Database starts up at 10:32:37 and processes all > > databases through autovacuum. > > Then exactly a minute later, it processes the postgres database. > > 5 seconds later, you get a SIGINT. > > > > Is there something wrong with autovacuum? Normally I would doubt it but > > the other possibility is something is waiting for just over a minute and > > then shutting down the database. > > > > If you su postgres, can you run pg_ctl and get the database up by itself? > > 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!! regards, leo > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com