Monday, January 31, 2011

How to install PostgreSQL 9.0 in CentOS 5

When installing postgreSQL in CentOS 5.0, you could follow the instruction show in the link http://yum.pgrpms.org/howtoyum.php.

But you could see the error like these...
apr-util-1.2.7-11.el5_5.1.x86_64 from installed has depsolving problems
  --> Missing Dependency: libpq.so.4()(64bit) is needed by package apr-util-1.2.7-11.el5_5.1.x86_64 (installed)
Error: Missing Dependency: libpq.so.4()(64bit) is needed by package apr-util-1.2.7-11.el5_5.1.x86_64 (installed)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

Hm, so important things are you should install two compat libraries.
sudo yum remove postgresql-libs
wget http://yum.pgsqlrpms.org/reporpms/9.0/pgdg-centos-9.0-2.noarch.rpm
wget http://yum.pgrpms.org/9.0/redhat/rhel-5.0-x86_64/compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm
wget http://yum.pgrpms.org/9.0/redhat/rhel-5.0-x86_64/compat-postgresql-libs-4-1PGDG.rhel5.i686.rpm
sudo rpm -ivh ./pgdg-centos-9.0-2.noarch.rpm
sudo rpm -ivh ./compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm
sudo rpm -ivh ./compat-postgresql-libs-4-1PGDG.rhel5.i686.rpm
sudo yum install postgresql-server

1 comment:

  1. This was incredibly useful for updating Subversion on a CentOS 6 box. Thanks!

    ReplyDelete