	Quick Steps to Install and Run PostgreSQL 
	-----------------------------------------
Login as root.

# rpm -qpl postgre*.rpm (to see list of files. For docs 'man rpm')
# rpm -qpi postgre*.rpm (to see info of package)
# cat /etc/passwd | grep postgres
  Note: If you see a 'postgres' user, you may need to backup and clean
  up the home directory ~postgres and delete the unix user 'postgres'
  or rename the unix user 'postgres' to something like 'postgres2'.
  Install must be "clean slate"
# rpm -i postgre*.rpm (Must install all packages clients, devel, data
         and main for pgaccess to work )
# chkconfig --add postgresql  (to start pg during booting, see 'man chkconfig')
# cp /usr/lib/pgsql/python/_pg.so /usr/lib/python1.5/lib-dynload (for python)
# /etc/rc.d/init.d/postgresql start  (to start up postgres)
# su - postgres
$ createdb mydatabase  (this will create a database by name 'mydatabase')
                 (for doc 'man createdb')
$ psql mydatabase   (for doc 'man psql')
$ pgaccess mydatabase (for docs 'man pgaccess')
  Now you can start banging away at SQL commands at pgaccess or psql !!
$ cd /usr/doc/postgresql* 
  Here read all the FAQs, User, Programmer, Admin guides and tutorials.

More details about PostgreSQL is at http://www.postgresql.org

	**************************************************
To verify the top quality of PostgreSQL, run the Regression test package :-
Login as root -
# rpm -i postgresql*.src.rpm
# cd /usr/src/redhat/SPECS
# more postgresql*.spec   (to see what system RPM packages you need to install)
# rpm -bp postgresql*.spec  (.. this will prep the package)

Regression test needs the Makefiles and some header files like *fmgr*.h 
which can be built by -
# rpm --short-circuit -bc postgresql*.spec ( .. use short circuit to bypass!)
Abort the build by CTRL+C, when you see 'make -C common  SUBSYS.o'
By this time configure is successful and all makefiles and headers
are created. You do not need to proceed any further
# cd /usr/src/redhat/BUILD
# chown -R postgres postgresql*
# su - postgres
$ cd /usr/src/redhat/BUILD/postgresql-6.4.2/src/test/regress
$ more README
$ make clean; make all runtest
$ more regress.out

	**************************************************

Testing PyGreSQL - Python interface
===================================
bash$ cd /usr/lib/pgsql/python 
bash$ /usr/bin/python 
>>> import _pg
>>> db = _pg.connect('thilo', 'localhost')
>>> db.query("INSERT INTO test VALUES ('ping', 'pong')")
>>> db.query("SELECT * FROM test")
eins|zwei
----+----
ping|pong
(1 row)
bash$ su  # Yow! Seems to work - now install it properly
bash# cp /usr/lib/pgsql/python/_pg.so /usr/lib/python1.5/lib-dynload 

Written By: Al Dev 
Email: alavoor@yahoo.com
