BASH script for collecting analyze-related info

I just sent off to this list for query help, and found the process of
gathering all the requested info somewhat tedious. So I created a little
BASH script to try to pull together as much of this information as
possible.

The script reads an analyze file, and generates SQL queries to retrieve the
following information:

- Postgres Version
- Changes to postgresql.conf
- Description of all tables scanned
- Description of all Indices
- Actual and estimated row counts for all the tables

Hopefully this may be of use to others as well. This list doesn't include
definitions for any views or custom functions--I don't think they're in the
analyze output, but if they are please let me know.

Any comments or suggestions for improvement would be most welcome. Thanks.

Ken

p.s., This script runs fine on my computer (Ubuntu 13.04), but on a Fedora
11 machine it dies with

pg_analyze_info.sh: line 18: unexpected EOF while looking for matching `)'
pg_analyze_info.sh: line 57: syntax error: unexpected end of file

If anyone knows why, or encounters a similar error and fixes it, please let
me know!

--
AGENCY Software
A data system that puts you in control
100% Free Software
*http://agency-software.org/*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing
list<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe>
to
learn more about AGENCY or
follow the discussion.