Postgres 8.4 on CentOS

Step which need to follow to install Postgres 8.4.

Default yum will install 8.1 but if you wan to install 8.4 use following steps.

[root@localhost tmp]# wget http://yum.pgrpms.org/reporpms/8.4/pgdg-centos-8.4-2.noarch.rpm


[root@localhost tmp]# rpm -Uvh pgdg-centos-8.4-2.noarch.rpm


[root@localhost tmp]# yum install postgresql postgresql-server postgresql-contrib

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.uhost.hk
 * updates: centos.uhost.hk
 * addons: mirror.centos.org
 * extras: centos.uhost.hk
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package postgresql-server.i386 0:8.4.14-1PGDG.rhel5 set to be updated
---> Package postgresql.i386 0:8.4.14-1PGDG.rhel5 set to be updated
--> Processing Dependency: postgresql-libs = 8.4.14-1PGDG.rhel5 for package: postgresql
---> Package postgresql-contrib.i386 0:8.4.14-1PGDG.rhel5 set to be updated
--> Processing Dependency: libossp-uuid.so.15 for package: postgresql-contrib
--> Running transaction check
--> Processing Dependency: libpq.so.4 for package: apr-util
--> Processing Dependency: libpq.so.4 for package: libdbi-dbd-pgsql
---> Package postgresql-libs.i386 0:8.4.14-1PGDG.rhel5 set to be updated
---> Package uuid.i386 0:1.5.1-4.rhel5 set to be updated
--> Running transaction check
---> Package compat-postgresql-libs.i686 0:4-1PGDG.rhel5 set to be updated
---> Package apr-util.i386 0:1.2.7-11.el5_5.2 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                    Arch     Version                   Repository  Size
================================================================================
Installing:
 postgresql                 i386     8.4.14-1PGDG.rhel5        pgdg84     1.6 M
 postgresql-contrib         i386     8.4.14-1PGDG.rhel5        pgdg84     432 k
 postgresql-server          i386     8.4.14-1PGDG.rhel5        pgdg84     5.0 M
Updating:
 apr-util                   i386     1.2.7-11.el5_5.2          base        80 k
 postgresql-libs            i386     8.4.14-1PGDG.rhel5        pgdg84     210 k
Installing for dependencies:
 compat-postgresql-libs     i686     4-1PGDG.rhel5             pgdg84      63 k
 uuid                       i386     1.5.1-4.rhel5             pgdg84      53 k

Transaction Summary
================================================================================
Install      5 Package(s)        
Update       2 Package(s)        
Remove       0 Package(s)        

Total download size: 7.5 M
Is this ok [y/N]: y
Downloading Packages:
(1/7): uuid-1.5.1-4.rhel5.i386.rpm                       |  53 kB     00:01    
(2/7): compat-postgresql-libs-4-1PGDG.rhel5.i686.rpm     |  63 kB     00:00    
(3/7): apr-util-1.2.7-11.el5_5.2.i386.rpm                |  80 kB     00:01    
(4/7): postgresql-libs-8.4.14-1PGDG.rhel5.i386.rpm       | 210 kB     00:02    
(5/7): postgresql-contrib-8.4.14-1PGDG.rhel5.i386.rpm    | 432 kB     00:02    
(6/7): postgresql-8.4.14-1PGDG.rhel5.i386.rpm            | 1.6 MB     00:08    
(7/7): postgresql-server-8.4.14-1PGDG.rhel5.i386.rpm     | 5.0 MB     00:25    
--------------------------------------------------------------------------------
Total                                           161 kB/s | 7.5 MB     00:47    
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating       : postgresql-libs                                   [1/9]
  Installing     : compat-postgresql-libs                            [2/9]
  Installing     : postgresql                                        [3/9]
  Updating       : apr-util                                          [4/9]
  Installing     : uuid                                              [5/9]
  Installing     : postgresql-contrib                                [6/9]
  Installing     : postgresql-server                                 [7/9]
  Cleanup        : apr-util                                          [8/9]
  Cleanup        : postgresql-libs                                   [9/9]

Installed: postgresql.i386 0:8.4.14-1PGDG.rhel5 postgresql-contrib.i386 0:8.4.14-1PGDG.rhel5 postgresql-server.i386 0:8.4.14-1PGDG.rhel5
Dependency Installed: compat-postgresql-libs.i686 0:4-1PGDG.rhel5 uuid.i386 0:1.5.1-4.rhel5
Updated: apr-util.i386 0:1.2.7-11.el5_5.2 postgresql-libs.i386 0:8.4.14-1PGDG.rhel5
Complete!


[root@localhost tmp]# rpm -qa | grep postgres
compat-postgresql-libs-4-1PGDG.rhel5
postgresql-contrib-8.4.14-1PGDG.rhel5
postgresql-8.4.14-1PGDG.rhel5
postgresql-server-8.4.14-1PGDG.rhel5
postgresql-libs-8.4.14-1PGDG.rhel5


     
[root@localhost tmp]# /etc/init.d/postgresql status
 is stopped

enjoy