Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9A9159FBCBC for ; Wed, 2 May 2007 12:49:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 86953-03 for ; Wed, 2 May 2007 12:49:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc3-s2.bay0.hotmail.com (bay0-omc3-s2.bay0.hotmail.com [65.54.246.202]) by postgresql.org (Postfix) with ESMTP id 14F119FBC82 for ; Wed, 2 May 2007 12:49:15 -0300 (ADT) Received: from hotmail.com ([64.4.38.32]) by bay0-omc3-s2.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 2 May 2007 08:49:15 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 2 May 2007 08:49:15 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Wed, 02 May 2007 15:49:14 GMT X-Originating-IP: [66.160.12.194] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com In-Reply-To: <1178119918.2953.5.camel@state.g2switchworks.com> From: "dx k9" To: pgsql-admin@postgresql.org Subject: Re: reindexdb hangs Date: Wed, 02 May 2007 11:49:14 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 02 May 2007 15:49:15.0000 (UTC) FILETIME=[6F7F0F80:01C78CD1] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.631 tagged_above=0 required=5 tests=AWL=-0.092, BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: * X-Archive-Number: 200705/23 X-Sequence-Number: 25343 Thanks for the response Scott. It turns out it was a temporary database and temporary table, that just wasn't there maybe it thought it was there from some type of snapshot then the next minute it was gone. Too bad we can't come up with a -e parameter for exclude say, Something like this would be nice reindexdb -a -e -p 4444 -e tempdb template1 The way it is now, I just have a 76 line script with each -d database . I also have to keep it up to date on my own, when they add a new or remove some database in the cluster. ~DjK _________________________________________________________________ Download Messenger. Join the i’m Initiative. Help make a difference today. http://im.live.com/messenger/im/home/?source=TAGHM_APR07