postgresql vs postgresql84

[Sergio Belkin]

I maintain the package UpTools-8.5.5-2.el5.i386.rpm that is in epel5
testing, but has dependency problems:

postgresql84-devel-8.4.7-1.el5_6.1.i386 from installed has depsolving problems
  --> postgresql84-devel conflicts with postgresql-devel
postgresql84-8.4.7-1.el5_6.1.i386 from installed has depsolving problems
  --> postgresql84 conflicts with postgresql
Error: postgresql84 conflicts with postgresql
Error: postgresql84-devel conflicts with postgresql-devel
 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

So I've modified the spec in order to use postgresql84 as requires but
now it outputs:

Transaction Check Error:
  file /usr/lib/libpq.so.4.1 from install of
postgresql-libs-8.1.23-1.el5_6.1.i386 conflicts with file from package
postgresqlclient81-8.1.11-1.el5s2.i386

What is the proper way to approach this issue?

Thanks in advance!

Transaction Check Error:
  file /usr/lib/libpq.so.4.1 from install of
postgresql-libs-8.1.23-1.el5_6.1.i386 conflicts with file from package
postgresqlclient81-8.1.11-1.el5s2.i386

[Devrim Gündüz]

On Sun, 2011-06-19 at 19:38 -0300, Sergio Belkin wrote:
> postgresql-libs-8.1.23-1.el5_6.1.i386 conflicts with file from package
> postgresqlclient81-8.1.11-1.el5s2.i386

Where does the second package comes from?

[Manuel Wolfshant]

On 06/23/2011 11:49 PM, Devrim GÜNDÜZ wrote:
> On Sun, 2011-06-19 at 19:38 -0300, Sergio Belkin wrote:
> > postgresql-libs-8.1.23-1.el5_6.1.i386 conflicts with file from package
> > postgresqlclient81-8.1.11-1.el5s2.i386
>
> Where does the second package comes from?

http://dev.centos.org/centos/5/testing/i386/RPMS/

[Sergio Belkin]

2011/6/23 Manuel Wolfshant :
> On 06/23/2011 11:49 PM, Devrim GÜNDÜZ wrote:
> > On Sun, 2011-06-19 at 19:38 -0300, Sergio Belkin wrote:
> > > postgresql-libs-8.1.23-1.el5_6.1.i386 conflicts with file from package
> > > postgresqlclient81-8.1.11-1.el5s2.i386
> >
> > Where does the second package comes from?
>
> http://dev.centos.org/centos/5/testing/i386/RPMS/

OK, it can be that that package is in testing, but anyway we have
postgresql and postgresql84 versions.

Hi, finally I left postgresql-devel as dependency instead
postgresql84-devel (the most conservative choice). Fix me if I am
wrong.

Greets.