Re: reindexdb hangs - Mailing list pgsql-admin

From dx k9
Subject Re: reindexdb hangs
Date
Msg-id BAY116-F2261C1BEF758D30196729DD1420@phx.gbl
Whole thread Raw
In response to Re: reindexdb hangs  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: reindexdb hangs  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: reindexdb hangs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: VACUUM FULL ANALYSE hanging
Next
From: Alvaro Herrera
Date:
Subject: Re: VACUUM FULL ANALYSE hanging