Skip site navigation (1) Skip section navigation (2)

Re: reindexdb hangs

From: "dx k9" <bitsandbytes88(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: reindexdb hangs
Date: 2007-05-02 15:49:14
Message-ID: BAY116-F2261C1BEF758D30196729DD1420@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
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


In response to

Responses

pgsql-hackers by date

Next:From: Scott MarloweDate: 2007-05-02 15:52:52
Subject: Re: reindexdb hangs
Previous:From: Tom LaneDate: 2007-05-02 15:46:44
Subject: Re: strange buildfarm failures

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2007-05-02 15:50:20
Subject: Re: VACUUM FULL ANALYSE hanging
Previous:From: Scott MarloweDate: 2007-05-02 15:40:59
Subject: Re: VACUUM FULL ANALYSE hanging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group