Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BCD9C9FBCFA for ; Wed, 2 May 2007 12:53:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76758-06 for ; Wed, 2 May 2007 12:52:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id DE4CE9FBCCB for ; Wed, 2 May 2007 12:52:53 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 2 May 2007 15:52:52 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 02 May 2007 10:52:53 -0500 Subject: Re: reindexdb hangs From: Scott Marlowe To: dx k9 Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1178121172.2953.18.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 02 May 2007 10:52:52 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/25 X-Sequence-Number: 25345 On Wed, 2007-05-02 at 10:49, dx k9 wrote: > 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. Had a similar problem at my last job. I wrote a bash script that used psql to get a list of databases and update the file that listed all the dbs to go through. We also used that list to do backups of each db individually.