| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-05-02 15:50:20 | Re: VACUUM FULL ANALYSE hanging |
| Previous Message | Scott Marlowe | 2007-05-02 15:40:59 | Re: VACUUM FULL ANALYSE hanging |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2007-05-02 15:52:52 | Re: reindexdb hangs |
| Previous Message | Tom Lane | 2007-05-02 15:46:44 | Re: strange buildfarm failures |