Ok,
As before, this script is basically a vacuumdb for indexes. I call it
reindexdb on my own system, and put it in the postgres binary directory
simply because it's indispensable in my system.
This should be the last one. Someone complained that assuming that the
script will reside in the same directory as psql was silly. That's
true, though eventually I'd like to see this, or a utility like it,
included in the official postgres distribution.
The script now uses various tricks to figure out where psql is.
Starting with path, continuing with the directory the script is in,
then whereis, and finally locate. These are arranged in order of speed
so it can find psql as fast as possible. Even so, the full iteration
through all methods takes less than a second.
If your system doesn't have whereis or locate, I've directed output from
all of these search commands to /dev/null so these tests will simply
fail if the command is unavailable.
Use, and enjoy.
--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas INN Database Administrator |
| Phone: (309) 743-0812 Fax : (309) 743-0830 |
| Email: sthomas@townnews.com AIM : trifthen |
| Web : www.townnews.com |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+