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

Thursday, October 4. 2012

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

I thought this is pretty straightforward, but I decided to write this post after getting a few emails recently.

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"

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

Enjoy!

Posted by Devrim GUNDUZ at 10:37 | Comments (3) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

My problem is that I find it nearly impossible to install the crypto contrib because of a missing library that I can't find or won't compile. And the pgagent is impossible to install because it requires those graphic libraries that I can never seem to find. Very frustrating. I have been tempted to try to

Have I tried these install? No not yet...I am just complaining to the "cloud".

#1 David A. Leedom (Homepage) on 2012-10-04 17:59 (Reply)

Hi,

Response from the cloud:

re: pgcrypto

After installing -contrib rpm, here is what you need to do:

postgres=# CREATE EXTENSION pgcrypto ;
CREATE EXTENSION

re: pgagent
Well, it depends on wx packages, which I supply in RPM repo.

D.

#1.1 Devrim GÜNDÜZ on 2012-10-04 19:17 (Reply)

Thank you for having this, couldn't find anything on starting 9.2.

#2 Ryan on 2012-12-11 22:06 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Enclosing asterisks marks text as bold (word), underscore are made via _word_. Standard emoticons like :-) and ;-) are converted to images. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information? Subscribe to this entry