How can I install PostgreSQL 9 on RHEL 6?

Question

I am new to RHEL 6 but have a project where I need a postgres 9 database and I only have RHEL 6 available to me. How can I safely do this? Should I install from source or is there a package around somewhere?

Solution 1

To install open-source version of PostgreSQL you have three ways:

• Compile and install PostgreSQL from source code. Take a look at Chapter 15 if you need some details how to accomplish such install.
• Install PostgreSQL from postgresql90 packages as ewwhite pointed.
• Use one-click installer provided by EnterpriseDB (Installation Guide).

Note that if you are doing something serious, then you probably should use latest minor version of PostgreSQL (at this time 9.0.4).

Solution 2

You can use the official RPMs available directly from PostgreSQL at: http://www.pgrpms.org/

Find the repo file for your preferred distribution and install from there.

Also see: PostgreSQL RPM Building Project - Yum Repository Howto

Comments

[ewwhite]

Did you specifically want to compile from source? You mentioned Red Hat 6, so I thought you'd be interested in an RPM-based solution.