Changes

==Mount Bear==

python -v

(ctrl-D) to get out if it works

==Build Postgres==

tar xf postgresql-9.1.2.tar

cd postgresql-9.1.2

Update missing packages needed for the build

yum install gcc gcc-c++ autoconf automake

yum install readline-devel zlib-devel python-devel

Now do the actual install ([http://www.postgresql.org/docs/9.1/interactive/install-procedure.html Official Instructions]):

gmake world

PostgreSQL, contrib and HTML documentation successfully made. Ready to install.

As root edit /etc/profile to include (before 'export PATH'):

/usr/local/pgsql/bin/createdb test

/usr/local/pgsql/bin/psql test

Make a database user:

/etc/init.d/iptables restart

Change postgres.conf:

maintenance_work_mem = 512MB

effective_cache_size = 14GB

Add access permissions to pg_hba.conf

host all all 128.32.67.0/24 trust

host all all 10.136.0.0/23 trust

Add to /etc/rc.local

/usr/local/pgsql/bin/pg_ctl start -l logfile -D /usr/local/pgsql/data

Start postgres with (if you've fixed the path then abbrev the first part)

or

/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start &

Note that the second command may fail silently if there is something wrong with the config, and the first uses the terminal unless you add the &.

netstat -tulpn

==Test==

Test by connecting remotely using a psql client on your desktop. Then enjoy!