Thread: libpq.so.3 compatability problem still there for 8.0.3 installs

Hi,

On Wed, 27 Jul 2005, Gregory Zelesnik wrote:

> I'm trying to upgrade to postgreSQL 8.0.3-1 from 7.3.6-7.  I'm having
> the same compatibility problem with libpq.so.3 that others seem to be
> having.
> After searching the web, I noticed that the solution seemed to be to
> download the compatibility package:
> compat-postgresql-libs-3-3PGDG.i686.rpm and install this first..
>
> I've downloaded it, and my attempt to install it produced the following
> conflict:
>
> error: Failed dependencies:
>        postgresql-libs < 8.0.2 conflicts with
> compat-postgresql-libs-3-3PGDG
>
> Can anyone help me with with an alternative way to solve the
> compatability problem?

Remove PostgreSQL-libs-8.0.2 rpm first... Or upgrade it to 8.0.3...
--
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr                      http://www.gunduz.org

Devrim,

Thank you so much for replying.

Actually, I do not have postgresql-libs v8.0.2 installed:

[gzelesnik@linus downloads]$ rpm -qa | grep postgres
rh-postgresql-devel-7.3.6-7
rh-postgresql-tcl-7.3.6-7
postgresql-docs-8.0.3-1PGDG
rh-postgresql-pl-7.3.6-7
rh-postgresql-libs-7.3.6-7
rh-postgresql-7.3.6-7
rh-postgresql-test-7.3.6-7
postgresql-jdbc-8.0.3-1PGDG
rh-postgresql-python-7.3.6-7
rh-postgresql-contrib-7.3.6-7
rh-postgresql-server-7.3.6-7
postgresql-odbc-7.3-3

------

And when I try to upgrade postgresql-libs v7.3.6-7 to v8.0.3, I get the
following conflicts:

[gzelesnik] rpm -Uv postgresql-libs-8.0.3-1PGDG.i686.rpm
error: Failed dependencies:
        libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG
        libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG
        libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG
        libpq.so.3 is needed by (installed) xemacs-21.4.13-8.ent
        libpq.so.3 is needed by (installed) mod_auth_pgsql-2.0.1-4.ent
        libpq.so.3 is needed by (installed) php-pgsql-4.3.2-14.ent
        libpq.so.3 is needed by (installed) perl-DBD-Pg-1.21-2
        libpq.so.3 is needed by (installed) rh-postgresql-python-7.3.6-7
        libpq.so.3 is needed by (installed) rh-postgresql-tcl-7.3.6-7
        libpq.so.3 is needed by (installed) rh-postgresql-7.3.6-7
        libpq.so.3 is needed by (installed)
rh-postgresql-contrib-7.3.6-7
        libpq.so.3 is needed by (installed) rh-postgresql-server-7.3.6-7
        postgresql-libs = 7.3.6 is needed by (installed)
rh-postgresql-devel-7.3.6-7
    Suggested resolutions:
        rh-postgresql-libs-7.3.6-7.i386.rpm

----

The conflict seems to be embedded in the set of packages for v8.0.3, and
the compat-postgresql-libs-3-3PGDG.rpm package doesn't seem to like
trying to upgrade from 7.3.6.

Any ideas?

Thank you!

Sincerely,
Greg

-----Original Message-----
From: Devrim GUNDUZ [mailto:devrim@gunduz.org]
Sent: Wednesday, July 27, 2005 5:32 PM
To: Gregory Zelesnik
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] libpq.so.3 compatability problem still there for
8.0.3 installs


Hi,

On Wed, 27 Jul 2005, Gregory Zelesnik wrote:

> I'm trying to upgrade to postgreSQL 8.0.3-1 from 7.3.6-7.  I'm having
> the same compatibility problem with libpq.so.3 that others seem to be
> having.
> After searching the web, I noticed that the solution seemed to be to
> download the compatibility package:
> compat-postgresql-libs-3-3PGDG.i686.rpm and install this first..
>
> I've downloaded it, and my attempt to install it produced the
following
> conflict:
>
> error: Failed dependencies:
>        postgresql-libs < 8.0.2 conflicts with
> compat-postgresql-libs-3-3PGDG
>
> Can anyone help me with with an alternative way to solve the
> compatability problem?

Remove PostgreSQL-libs-8.0.2 rpm first... Or upgrade it to 8.0.3...
--
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr                      http://www.gunduz.org

Hi,

On Thu, 28 Jul 2005, Gregory Zelesnik wrote:

> Actually, I do not have postgresql-libs v8.0.2 installed:
>
> [gzelesnik@linus downloads]$ rpm -qa | grep postgres
> rh-postgresql-devel-7.3.6-7
> rh-postgresql-tcl-7.3.6-7
> postgresql-docs-8.0.3-1PGDG
> rh-postgresql-pl-7.3.6-7
> rh-postgresql-libs-7.3.6-7
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You have a libs version which is smaller than 8.0.3

> And when I try to upgrade postgresql-libs v7.3.6-7 to v8.0.3, I get the
> following conflicts:
>
> [gzelesnik] rpm -Uv postgresql-libs-8.0.3-1PGDG.i686.rpm
> error: Failed dependencies:
>        libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG
>        libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG
>        libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG
>        libpq.so.3 is needed by (installed) xemacs-21.4.13-8.ent
>        libpq.so.3 is needed by (installed) mod_auth_pgsql-2.0.1-4.ent
>        libpq.so.3 is needed by (installed) php-pgsql-4.3.2-14.ent
>        libpq.so.3 is needed by (installed) perl-DBD-Pg-1.21-2
>        libpq.so.3 is needed by (installed) rh-postgresql-python-7.3.6-7
>        libpq.so.3 is needed by (installed) rh-postgresql-tcl-7.3.6-7
>        libpq.so.3 is needed by (installed) rh-postgresql-7.3.6-7
>        libpq.so.3 is needed by (installed)
> rh-postgresql-contrib-7.3.6-7
>        libpq.so.3 is needed by (installed) rh-postgresql-server-7.3.6-7
>        postgresql-libs = 7.3.6 is needed by (installed)
> rh-postgresql-devel-7.3.6-7
>    Suggested resolutions:
>        rh-postgresql-libs-7.3.6-7.i386.rpm
> ----
>
> The conflict seems to be embedded in the set of packages for v8.0.3, and
> the compat-postgresql-libs-3-3PGDG.rpm package doesn't seem to like
> trying to upgrade from 7.3.6.

Please don't use rpm -Uvh while upgrading PostgreSQL in major version
upgrades. Take a dump and backup, remove the existing RPMs and install new
ones.

Then you'll have no trouble.

Regards,

  --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr                      http://www.gunduz.org