From: dx k9 <bitsandbytes88@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: reindexdb hangs
Date: Wed, 02 May 2007 11:49:14 -0400
Message-ID: <BAY116-F2261C1BEF758D30196729DD1420@phx.gbl> (raw)
In-Reply-To: <1178119918.2953.5.camel@state.g2switchworks.com>
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 im Initiative. Help make a difference today.
http://im.live.com/messenger/im/home/?source=TAGHM_APR07
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bitsandbytes88@hotmail.com
Subject: Re: reindexdb hangs
In-Reply-To: <BAY116-F2261C1BEF758D30196729DD1420@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox