How do I find the latest supported copy of (official)Postgresql?

The latest 9.0.0-1
 If you use a package manager like rpm (e.g., RedHat, SuSE, Mandrake), use this to verify
   tallac$ rpm -q postgresql


Download the rpms from http://www.postgresql.org/ftp/binary...x/rpms/redhat/ 

Also here is a link to help you install

http://www.directadmin.com/forum/showthread.php?p=189959

I appologize the latest is 9.0.3

We are looking for the newest version of postgres available for RHEL 5 32. Which version would that be? Also which PGAdmin would go with that version?

Thanks, Missymadi

Also Here is the YUM Repository Howto

http://yum.pgrpms.org/howtoyum.php

I am working with someone on this and they advised that we should be using Postgres version 8.1.23 because it is a "certified" release with RHEL5. If I have to use 8.1.23 what version on PGAdmin would i use? And when I download how do I determine that it is in fact a certified release of PGAdmin?

For the YUM option, we are not connected to the internet for this box.

PostgreSQL 8.1 is the "norm" on RHEL 5, Red Hat gave us a gift in their RHEL 5.5 update. It now includes separate PostgreSQL 8.4 packages that may optionally be used on RHEL 5 instead of PostgreSQL 8.1. (Both can't be used on the same system at the same time.)

You can use PGadmin 3

i recieved my answer of the pgadmin version