My Notepad

1. yum install postgresql postgresql-server postgresql-jdbc postgresql-devel
2. /usr/bin/initd -D /var/lib/pgsql/data/
3. /usr/bin/pg_ctl -D /var/lib/pgsql/data/ -l /var/lib/pgsql/data/logfile start
4. /usr/bin/createdb test
5. /usr/bin/psql test
6. "ctrl + z" to exit

*N.B* Sometime you might fail to stop postmaster proccess using "pg_ctl ... stop" command, you
can try to kill the postmaster process. If still doesn't work, try
kill -9 43232 (suppose 43232 is the pid for postmaster process)
And then delete postmaster.pid under /var/lib/pgsql/data/.

----------------------------------------------------------------------------
In order to set up RFT in globus toolkit 4, we need to set up postgreSQL to accept tcp connection.
1. restart the postmaster using:
/usr/bin/pg_ctl -D /var/lib/pgsql/data/ -l /var/lib/pgsql/data/logfile -o -i start
2. vi /var/lib/pgsql/data/pg_hba.conf
Add the following line to the bottem:
host rftDatabase "synew" "163.1.26.6" 255.255.255.255 md5
3. As root, run:
/etc/init.d/postgresql restart

*N.B.* PostgreSQL support kerberos authentication by default!! The tgt ticket itself will give you the full access to postgreSQL!
Therefore if you have a ticket as "synew", no matter what the linux username is, you are allowed to access postgresSQL as long as you have created a user " synew" for PostgreSQL.
If you don't want to use kerberos authencation, given the above line added to pg_hba.conf already, you can erase the kerberos ticket by using: kdestroy.