Installing PGDG on a fresh CentOS 5.6 - Mailing list pgsql-general

From Alexander Farber
Subject Installing PGDG on a fresh CentOS 5.6
Date
Msg-id BANLkTikwgRfKEOCKNeuoHerLdLSWepb_nw@mail.gmail.com
Whole thread Raw
Responses Re: Installing PGDG on a fresh CentOS 5.6
Re: Installing PGDG on a fresh CentOS 5.6
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using column aliasses in the same query
Next
From: John R Pierce
Date:
Subject: Re: Installing PGDG on a fresh CentOS 5.6