Обсуждение: Installing PGDG on a fresh CentOS 5.6

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

On 04/17/11 11:05 AM, Alexander Farber wrote:
> ...
> --->  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
> ...
> 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)
> ...

odd, that compat-postgresql.libs should have worked ... OH! you have
i386 (32 bit) postgresql.devel and are installing 64bit otherstuffs.

remove it.

rpm -e postgresql-devel

THEN install the 64 bit shiny new stuff, and all should be good.   if
you need the 32 bit postgresql-devel, you can install that too seperately

Alexander Farber <alexander.farber@gmail.com> writes:
> 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:

I'm not sure if CentOS is caught up, but postgresql 8.4.7 is available
for RHEL5 from Red Hat --- it's called "postgresql84".  Possibly you'd
have better luck with that than with Devrim's RPMs.

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

It seems to be trying to update a 32-bit version of postgresql-devel:

> ---> Package postgresql-devel.i386 0:8.1.23-1.el5_6.1 set to be updated

If you have that installed, you probably need to remove it before you
can install a 64-bit version, quite aside from any version differences.
-devel packages typically are not multilib safe.

            regards, tom lane

Thank you Tom, "yum install postgresql84" has worked for CentOS 5.6/64 bit