HeatWare.net header image
HeatWare.net
TwitterRSSEmail
  • Home
  • Windows
    • Windows 8
    • Windows 7
    • Windows Vista
    • Windows XP
  • Linux/Unix
  • Mac
  • Mobile
    • Android
    • iOS
    • Phones (Help / Resources)
  • Software / Programming
    • Free Software
    • Programming – General
    • PHP
    • Ruby/Rails
    • Quality Assurance (QA)
    • Software – General
    • Software Help
    • Databases
  • Cool Websites
  • Other
    • Deals & Bargains
    • News
    • Video Games
    • Hardware
    • Electronics
  • About

3 comments / February 16, 2011 / sood / Databases, Linux/Unix

How to install PostgreSQL 8.4 on CentOS 5.5

If you have tried installing PostgreSQL database on CentOS 5.5 using yum, you will notice that you an old, outdated version! There are several ways to get the 8.4.x version of Postgres installed on this OS, but here is the quick and easy method!

Installing PostgreSQL 8.4.x on CentOS 5.5

  • Download the PostgreSQL 8.4 repository RPM
    wget http://yum.pgrpms.org/reporpms/8.4/pgdg-centos-8.4-2.noarch.rpm
  • Add the repository
    rpm -ivh pgdg-centos-8.4-2.noarch.rpm
  • Use yum to install PostgresSQL
    yum install -y postgresql postgresql-server
  • Initialize the database
    service postgresql initdb
  • Start the database
    service postgresql restart
  • Automatically start database on boot
    chkconfig postgresql on

Related Posts

  • How to install Ruby 1.8.7 on CentOS 5.5 Linux
  • Find PostgreSQL database size using SQL 'Select'
  • How to backup/dump a PostgreSQL database using pg_dump
  • How to install a FTP server on Linux in 30 seconds
  • How to install RubyGems on Linux (Ubuntu & Other)

Databases Linux Postgres PostgreSQL

3 comments… add one
  1. Matt October 10, 2011, 9:25 am

    When service postgresql initdb:

    If (“Data directory is not empty”)
    {
    (
    rm -f -r /usr/local/pgsql/data
    or
    rm -f -r /var/lib/pgsql/data
    )
    su postgres
    initdb -D /var/lib/pgsql/data
    };

  2. davidtaubmann October 18, 2012, 3:14 am

    Your links are deprecated, they should now be based in http://yum.pgrpms.org/reporpms/

  3. sood April 29, 2013, 2:14 pm

    Thanks David, I have updated the URL in the article.

Cancel reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • Why You Should Consider Diving Apps
  • How to Buy a Smartphone that Fits Your Budget
  • How to Overcome Frustrating PDF Stress
  • Convert PDF to Word: Easy, Reliable and Quality Conversion
  • PDF to Excel App ­ – A New Way of Handling Tricky Documents

Recent Comments

  • Valarie Walter on Basic Troubleshooting Steps for your Cell Phone
  • John Mists on A Brief History of Android OS
  • syarif on PostgreSQL: How to reload config settings without restarting database
  • Raghu on How to SSH to a server using Ruby – Part I
  • francisco clemente on Basic Troubleshooting Steps for your Cell Phone

Tags

ACSLS Android Cell Phones Cool Software Cool Websites Databases Facebook File System Free Software G2x Galaxy S5 Hot Deals iOS iPhone ISO LG Linux Linux/Unix Mac Mobile mysql OpenStack OS X PHP Postgres PostgreSQL Printers Programming ruby Samsung Galaxy S6 Shell Smartphones Sun T-Mobile Tips Tips & Tricks Ubuntu Unix Virtualization VMWare Windows Windows 7 Windows 8 Windows Vista Windows XP

Latest Tweet

Follow @HeatwaredotNet

SP
@HeatwaredotNet

  • Why You Should Consider Diving Apps https://t.co/Is41cdUv2I #diving-apps
    about 5 years ago

All Categories

Other Links

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2015 — HeatWare