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