1. Install the packages:

root:/mnt/cdrom/RedHat/RPMS# rpm -i postgresql-6.5.2-1.i386.rpm
root:/mnt/cdrom/RedHat/RPMS# rpm -i postgresql-server-6.5.2-1.i386.rpm
root:/mnt/cdrom/RedHat/RPMS# rpm -i postgresql-devel-6.5.2-1.i386.rpm
root:/mnt/cdrom/RedHat/RPMS# rpm -i postgresql-perl-6.5.2-1.i386.rpm
root:/mnt/cdrom/RedHat/RPMS# rpm -i postgresql-tcl-6.5.2-1.i386.rpm

2. Su into the user postgres and run "initdb" to initialize the database server. For example:

bash$ initdb --pglib=/usr/lib/pgsql --pgdata=/var/lib/pgsql

3. As root, Run the database server:

root:~# /etc/rc.d/init.d/postgresql start

4. Using the postgres user, create a database user for every user who wishes to use the database. Using the "createuser" utility:

bash$ createuser shlomi
Enter user's postgres ID or RETURN to use unix user ID: 500 ->
Is user "shlomi" allowed to create databases (y/n) y
Is user "shlomi" a superuser? (y/n) n
createuser: shlomi was successfully added

5. Login as a regular user, and create a database using createdb:

shlomi:~# createdb test