How to set up PostgreSQL 7.1, the `Sauron way...

 1. wget ftp://ftp.postgresql.org/pub/v7.1/postgresql-7.1.tar.gz
 2. tar zxvf postgres-7.1.tar.gz
 3. cd postgres-7.1/
 4. ./configure --with-yourown-options
 5. make && make install (This will install binaries in /usr/local/pgsql/bin)
 6. Create a user (or use an existing user) to run the database as. (We
    will call this user "postgres" from now, to make it easier)
    Also, determine where you wish to store the data files (We'll assume
    /var/lib/pgsql/data for sake of making it easier to explain)
 7. mkdir -p /var/lib/pgsql/data
 8. chown -R postgres.postgres /var/lib/pgsql
 9. su postgres
11. initdb /var/lib/pgsql/data
12. /usr/lib/pgsql/bin/postmaster -i -o -F -D /var/lib/pgsql/data > \
    /var/log/postgres.log 2>&1
13. psql template1
    (If you get an error along the lines of: "psql: error in loading
    shared libraries: libpq.so.2.1: cannot open shared object file: No
    such file or directory", then do the following):
    13a. echo "/usr/local/pgsql/lib" >> /etc/ld.so.conf
    13b. ldconfig -v
14. CREATE USER testuser CREATEDB;
15. \q (exit out of psql)
16. psql template1 testuser
17. CREATE DATABASE testuser;
18. Go have a cold beer, Congratulations.