pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 i’m Initiative. Help make a difference today. 
http://im.live.com/messenger/im/home/?source=TAGHM_APR07




view thread (14+ messages)  latest in thread

Message-ID: <BAY116-F2261C1BEF758D30196729DD1420@phx.gbl>
Permalink:  ../BAY116-F2261C1BEF758D30196729DD1420@phx.gbl/
Also on:    postgresql.org/message-id/BAY116-F2261C1BEF758D30196729DD1420@phx.gbl

 · 

reply

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