Installing PGDG on a fresh CentOS 5.6

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Installing PGDG on a fresh CentOS 5.6
Date: 2011-04-17 18:05:55
Message-ID: BANLkTikwgRfKEOCKNeuoHerLdLSWepb_nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have installed CentOS from a CentOS-5.6-x86_64-bin-DVD-1of2.iso
and then installed PGDG because I want to have PostgreSQL 8.4.7:

# rpm -Uvh http://www.pgrpms.org/8.4/redhat/rhel-5-x86_64/pgdg-centos-8.4-2.noarch.rpm

# cat /etc/yum.repos.d/pgdg-84-centos.repo
[pgdg84]
name=PostgreSQL 8.4 $releasever - $basearch
baseurl=http://yum.pgrpms.org/8.4/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG

[pgdg84-source]
name=PostgreSQL 8.4 $releasever - $basearch - Source
failovermethod=priority
baseurl=http://yum.pgrpms.org/srpms/8.4/redhat/rhel-$releasever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG

Then I'm trying to install the PGDG-packaged PostgreSQL,
but keep getting the error message I don't understand:

# sudo yum install postgresql-server postgresql-devel postgresql-docs postgresql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.atrpms.net
* extras: mirror.atrpms.net
* updates: mirror.atrpms.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package postgresql.x86_64 0:8.4.7-1PGDG.rhel5 set to be updated
--> Processing Dependency: postgresql-libs = 8.4.7-1PGDG.rhel5 for
package: postgresql
--> Processing Dependency: libpq.so.5()(64bit) for package: postgresql
---> Package postgresql-devel.i386 0:8.1.23-1.el5_6.1 set to be updated
--> Processing Dependency: postgresql = 8.1.23-1.el5_6.1 for package:
postgresql-devel
---> Package postgresql-devel.x86_64 0:8.4.7-1PGDG.rhel5 set to be updated
---> Package postgresql-docs.x86_64 0:8.4.7-1PGDG.rhel5 set to be updated
---> Package postgresql-server.x86_64 0:8.4.7-1PGDG.rhel5 set to be updated
--> Running transaction check
---> Package postgresql-devel.i386 0:8.1.23-1.el5_6.1 set to be updated
--> Processing Dependency: postgresql = 8.1.23-1.el5_6.1 for package:
postgresql-devel
--> Processing Dependency: libpq.so.4()(64bit) for package: php53-pgsql
--> Processing Dependency: libpq.so.4()(64bit) for package: apr-util
--> Processing Dependency: libpq.so.4()(64bit) for package: perl-DBD-Pg
---> Package postgresql-libs.x86_64 0:8.4.7-1PGDG.rhel5 set to be updated
--> Running transaction check
---> Package compat-postgresql-libs.x86_64 0:4-1PGDG.rhel5 set to be updated
---> Package postgresql-devel.i386 0:8.1.23-1.el5_6.1 set to be updated
--> Processing Dependency: postgresql = 8.1.23-1.el5_6.1 for package:
postgresql-devel
--> Finished Dependency Resolution
postgresql-devel-8.1.23-1.el5_6.1.i386 from updates has depsolving problems
--> Missing Dependency: postgresql = 8.1.23-1.el5_6.1 is needed by
package postgresql-devel-8.1.23-1.el5_6.1.i386 (updates)
Error: Missing Dependency: postgresql = 8.1.23-1.el5_6.1 is needed by
package postgresql-devel-8.1.23-1.el5_6.1.i386 (updates)
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.

I've tried to find a combination of packages which would work,
but haven't succeeded. Here are the currently installed packages:

# rpm -qa|grep -i "\\<pg"
pgdg-centos-8.4-2
php53-pgsql-5.3.3-1.el5_6.1
perl-DBD-Pg-1.49-2.el5_3.1

# rpm -qa|grep -i post
postgresql-libs-8.1.23-1.el5_6.1
postgresql-libs-8.1.23-1.el5_6.1

Does anybody know the magic command for me? (besides "man yum" :-)

Thank you
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-04-17 18:28:45 Re: Installing PGDG on a fresh CentOS 5.6
Previous Message Tom Lane 2011-04-17 16:00:39 Re: Using column aliasses in the same query