Skip to content

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 9.2 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!

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

David A. Leedom on :

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".

Devrim GÜNDÜZ on :

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.

Deon Frankenfield on :

I was just looking for this information for a while. After 6 hours of continuous Googleing, at last I got it in your web site. I wonder what is the lack of Google strategy that don't rank this kind of informative sites in top of the list. Usually the top sites are full of garbage.

Ryan on :

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

Gurjeet Singh on :

I used pgdg-centos92-9.2-6.noarch.rpm and it seems that the group name is missing '9.2'. The command that worked for me is

yum groupinstall "PostgreSQL Database Server 9.2 PGDG"

Devrim Gündüz on :

Hi Gurjeet,

Right, I had to change it recently, for multi version installation Let me update this post. Thanks for the heads up!

Regards, Devrim

Geraldo Jannett on :

Do you mind if I quote a couple of your messages as long as I give credit and also resources back to your website? My blog site is on the very same specific niche as yours, and also my individuals would gain from several of the information you provide right here. Please let me know if this ok with you. Thanks.

Edison Nolton on :

I'm really impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself? Anyway keep up the nice quality writing, it is rare to see a nice blog like this one nowadays..

sea freight forwarding Chandigarh on :

I discovered your blog site on google and check a few of your early posts. Continue to keep up the very good operate. I just additional up your RSS feed to my MSN News Reader. Seeking forward to reading more from you later on!?

Daryl Mcmillin on :

It's best to participate in a contest for probably the greatest blogs on the web. I'll suggest this website!

BryanPoura on :

Hi, here on the forum guys advised a cool Dating site, be sure to register - you will not REGRET it https://bit.ly/3hhve2N

gookerdoughboy777 on :

Next time I read a blog, Hopefully it does not disappoint me as much as this one. After all, Yes, it was my choice to read through, but I genuinely believed you’d have something useful to say. All I hear is a bunch of moaning about something that you can fix if you weren’t too busy searching for attention.

Vertie Felps on :

It's a pity you don't have a donate button! I'd certainly donate to this superb blog! I guess for now i'll settle for book-marking and adding your RSS feed to my Google account. I look forward to new updates and will talk about this website with my Facebook group. Talk soon!

Cruz Hessel on :

I’m impressed, I have to say. Actually rarely do I encounter a blog that’s both educative and entertaining, and let me inform you, you could have hit the nail on the head. Your concept is outstanding; the issue is one thing that not sufficient people are speaking intelligently about. I am very completely satisfied that I stumbled throughout this in my seek for one thing relating to this. I pay 3 bucks for hosting and it's great. Here it is: https://bit.ly/3DollarHost

Eddie Mahn on :

I do believe all of the ideas you've offered to your post. They are really convincing and will certainly work. Still, the posts are too short for novices. May you please lengthen them a bit from subsequent time? Thanks for the post.

Jarrod Herren on :

great issues altogether, you simply won a emblem new reader. What would you recommend in regards to your submit that you made some days in the past? Any positive? Its easy to buy Bitcoin or ETH with credit or debit card. Here is how: https://www.no1geekfun.com/how-to-buy-bitcoin-2021/

Booker Fanton on :

Hey man, thanks for sharing such a great short article. We're utilizing Hootsuite at my work environment and aren't thrilled with it. Glad to have this source to make pointers with moving forward!

Christel Coppedge on :

Hi there, You've done an incredible job. I will definitely digg it and personally suggest to my friends. I am confident they'll be benefited from this site.

Regine Kernagis on :

F*ckin’ amazing things here. I’m very glad to see your post. Thanks a lot and i am looking forward to contact you. Will you kindly drop me a e-mail?

Randaljak on :

музыка самая самая

JeffreyBax on :

скачать песнью бесплатно

WilsonBuh on :

слушать музыку онлайн бесплатно без

Davidnor on :

песню будете

Michaelbed on :

песни 2021 бесплатно

Add 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.
CAPTCHA

Form options