• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

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

Experts,

       We run RHEL5 here. How can I find out what version of Postgresql  is supported and is an official copy? I thought it would have been Postgresql9.0.3 but a co-worker believes that it is 8.1.23. How do we verify the correct copy to use?

Thanks, Missymadi
0
missymadi
Asked:
missymadi
  • 5
  • 5
3 Solutions
 
meko72Commented:
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
0
 
meko72Commented:
I appologize the latest is 9.0.3
0
 
earth man2Commented:
Depends on whether you will migrate the database table data to new major version or only upgrade the executables and object libraries.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
missymadiAuthor Commented:
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
0
 
meko72Commented:
9.0.3 is the latest for RHEL 5.32  and you can use  pgadmin3-1.12.1-1
0
 
meko72Commented:
Also Here is the YUM Repository Howto

http://yum.pgrpms.org/howtoyum.php
0
 
missymadiAuthor Commented:
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?
0
 
missymadiAuthor Commented:
For the YUM option, we are not connected to the internet for this box.

0
 
meko72Commented:
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

0
 
missymadiAuthor Commented:
For PostgreSQL-8.1.23 what version of PGAdmin? Such as PGAdmin3-1.8.0.

Thanks, MissyMadi
0
 
missymadiAuthor Commented:
i recieved my answer of the pgadmin version
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now