Re: [GENERAL] Installing PGDG on a fresh CentOS 5.6

2011-04-21 Thread Alexander Farber
Thank you Tom, "yum install postgresql84" has worked for CentOS 5.6/64 bit

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Installing PGDG on a fresh CentOS 5.6

2011-04-17 Thread Tom Lane
Alexander Farber  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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Installing PGDG on a fresh CentOS 5.6

2011-04-17 Thread John R Pierce

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




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Installing PGDG on a fresh CentOS 5.6

2011-04-17 Thread Alexander Farber
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 "\\http://www.postgresql.org/mailpref/pgsql-general