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 B424611F6A70 for ; Thu, 30 Mar 2006 13:10:16 -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 16429-06 for ; Thu, 30 Mar 2006 13:10:14 -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 0C0F511F6983 for ; Thu, 30 Mar 2006 13:10:13 -0400 (AST) Received: (qmail 27266 invoked from network); 30 Mar 2006 17:10:10 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 30 Mar 2006 17:10:10 -0000 Message-ID: <442C10F1.2060005@metatrontech.com> Date: Thu, 30 Mar 2006 09:10:09 -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: Tom Lane , pgsql-admin@postgresql.org Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! References: <20060330165846.93504.qmail@web30813.mail.mud.yahoo.com> In-Reply-To: <20060330165846.93504.qmail@web30813.mail.mud.yahoo.com> Content-Type: multipart/mixed; boundary="------------020708050604080109040601" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104, MANY_EXCLAMATIONS=0] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200603/380 X-Sequence-Number: 21137 This is a multi-part message in MIME format. --------------020708050604080109040601 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit lmyho wrote: > >The last one (successful bootup and shutdown): >pg_log# more postgresql-2006-03-30_103237.log >2006-03-30 10:32:37 CSTLOG: database system was shut down at 2006-03-30 10:32:20 >CST >2006-03-30 10:32:37 CSTLOG: checkpoint record is at 0/33B96C >2006-03-30 10:32:37 CSTLOG: redo record is at 0/33B96C; undo record is at 0/0; >shutdown TRUE >2006-03-30 10:32:37 CSTLOG: next transaction ID: 5839; next OID: 16386 >2006-03-30 10:32:37 CSTLOG: next MultiXactId: 1; next MultiXactOffset: 0 >2006-03-30 10:32:37 CSTLOG: database system is ready >2006-03-30 10:32:37 CSTLOG: transaction ID wrap limit is 2147484146, limited by >database "postgres" >2006-03-30 10:32:37 CSTLOG: autovacuum: processing database "template1" >2006-03-30 10:33:37 CSTLOG: autovacuum: processing database "postgres" >2006-03-30 10:33:42 CSTLOG: incomplete startup packet >2006-03-30 10:33:42 CSTLOG: received fast shutdown request >2006-03-30 10:33:42 CSTLOG: shutting down >2006-03-30 10:33:42 CSTLOG: database system is shut down >2006-03-30 10:33:42 CSTLOG: logger shutting down > >You can see they all have that line! Can you see what's may be the problem? Thank >you!!! > > 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? Best Wishes, Chris Travers Metatron Technology Consulting --------------020708050604080109040601 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 --------------020708050604080109040601--