As per the [PostgreSQL web site]:

PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere.

These installation instructions assume

These are the Package(s) and available here:

There are certain prerequisites before compiling the PostgreSQL program, you must verify that egcs-c++-version.i386.rpm package is installed on your system. The egcs-c++-version.i386.rpm package is located in you Red Hat Linux CD-ROM under RedHat/RPMS subdirectory. After compilation and installation of PostgreSQL you can remove this package from your system. To verify that egcs-c++-version.i386.rpm is already installed, use the following command:

                 [root@deep] /# rpm -q egcs-c++
               

To install egcs-c++-version.i386.rpm, use the following command:

                 [root@deep] /# mount /dev/cdrom /mnt/cdrom
                 [root@deep] /# cd /mnt/cdrom/RedHat/RPMS
                 [root@deep ]/RPMS# rpm -Uvh egcs-c++-version.i386.rpm
               

                 egcs-c++                    ##################################################
               

Before you decompress the tarballs, it is a good idea to make a list of files on the system before you install it, and one afterwards, and then compare them using diff to find out what file it placed where. Simply run find /* > PostgreSQL1 before and find /* > PostgreSQL2 after you install the tarball, and use diff PostgreSQL1 PostgreSQL2 > PostgreSQL-Installed to get a list of what changed.

To Compile you need to decompress the tarball -tar.gz:

                 [root@deep] /# cp postgresql-version.tar.gz /var/tmp
                 [root@deep] /# cd /var/tmp
                 [root@deep ]/tmp# tar xzpf postgresql-version.tar.gz