Thread: installation of postgres 8.3 on CentOs 5.1

__________ Information from ESET Smart Security, version of virus signature database 2878 (20080215) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Hello Nic,

Is this a test server?  If so, try this.  Find the correct name of
postgres-libs (rpm -qa | grep postgres-libs), and do this:

rpm -e postgres-libs --nodeps

Then, first install a package like so:

rpm -i compat-postgresql-libs-4-1PGDG.rhel5

(Note that this isn't the correct filename - I don't have the correct
filename offhand as this particular box still has 8.2.4 installed.)  The
point is, you can force deletion of the CentOS-supplied packages and
install the compat-libs and libs provided by PGSQL first, then go on with
the server or whatever other packages you need.

I've been doing this for a long time starting with C4.5 as the
PGDG-provided packages are newer than the OS-provided packages.

Let me know if that works, or doesn't.  As always, be sure to conduct
extensive testing with your application to ensure that this doesn't break
things, before doing this in a production capacity.  In my experience it
hasn't broken things.

Cheers,
-J

On Fri, 15 Feb 2008, Nicholas Hemley wrote:

> Date: Fri, 15 Feb 2008 12:07:06 -0000
> From: Nicholas Hemley <nic.hemley@sidonis.com>
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] installation of postgres 8.3 on CentOs 5.1
>
> Hello,
>
>
>
> I am attempting to install postgres 8.3 onto a centos 5.1 (Redhat 5) server
> and am having the following difficulty.
>
>
>
> Basically, the currently installed postgresql-libs package cannot be removed
> since there is a dependency on it from the apr-util package
>
>
>
> Therefore, i am unable to remove the older 8.1 package in order to install
> the 8.3 RPMs
>
>
>
> Any ideas from people? Is the only way to force it?
>
>
>
> Cheerio,
>
> Nic Hemley
>
>

Hi,

On Fri, 2008-02-15 at 12:07 +0000, Nicholas Hemley wrote:
>
> Basically, the currently installed postgresql-libs package cannot be
> removed since there is a dependency on it from the apr-util package
>
> Therefore, i am unable to remove the older 8.1 package in order to
> install the 8.3 RPMs

rpm -ivh compat-postgresql-libs... --replacefiles

This will replace the files. Then try removing postgresql-libs. Now you
should be able to remove it, since libpq that apr-util is looking for is
already satisfied.

There is an excellent guide about this issue:

http://www.westnet.com/~gsmith/gregsmith/content/postgresql/pgrpm.htm

The package repository at http://yum.pgsqlrpms.org will solve these
problems after you fix the compat rpm issue.

Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/