How to install PostgreSQL 9.2 on RHEL/CentOS/Scientific Linux 5 and 6

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

First, download PostgreSQL 9.2 repo package from here. Please pick up the correct repo file per your distro and architecture. If you are not sure about your OS version, run

cat /etc/redhat-release

Install the repo RPM. For example, if you downloaded repo RPM for RHEL 6, here is your command:

rpm -ivh pgdg-redhat92-9.2-7.noarch.rpm

Alternatively, you can install the package directly by using the repo RPM URL:

rpm -ivh http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm

Now, you can install PostgreSQL 9.2 with single command:

yum groupinstall “PostgreSQL Database Server PGDG”

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

This will install PostgreSQL 9.2 server, along with -contrib subpackage. If you don’t want -contrib subpackage, you can use

yum install postgresql92-server

to install 9.2 on your machine. Once it is installed, first initialize the cluster:

service postgresql-9.2 initdb

Now, you can start PostgreSQL 9.2:

service postgresql-9.2 start

If you want PostgreSQL 9.2 to start everytime on boot, run this:

chkconfig postgresql-9.2 on


Read More