the PGDG .rpm's for RHEL4 have a bit of an annoyance...

RHEL4 ships with postgres 7.4.x, and various RHEL4 RPMs have a
dependency on libpq.so.3 ...

# rpm -Uvh postgresql-8.2.3-1PGDG.i686.rpm \
> postgresql-libs-8.2.3-1PGDG.i686.rpm \
> postgresql-server-8.2.3-1PGDG.i686.rpm \
> postgresql-contrib-8.2.3-1PGDG.i686.rpm \
> compat-postgresql-libs-4-2PGDG.rhel4.i686.rpm
warning: /var/tmp/rpm-xfer.N9M9NQ: V3 DSA signature: NOKEY, key ID 20579f11
error: Failed dependencies:
libpq.so.3 is needed by (installed) dovecot-0.99.11-4.EL4.i386


compat-postgresql-libs-4-2PGDG.rhel4.rpm supplies libpq.so.4 and .4.1,
but it does NOT include .so.3. I think it should provide a .so.3 which
can coexist with the rest of the 8.2.3 stack (or, there should be a
compat-postgresql-libs-3 ?)





---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

John R Pierce wrote:
> RHEL4 ships with postgres 7.4.x, and various RHEL4 RPMs have a
> dependency on libpq.so.3 ...

Using the CentOS 4 base repository, I've identified these RPMs as
depending on libpq.so.3, which is obsoleted and removed by the
postgresql-libs-8.2.3-1PGDG RPM ...

cyrus-sasl-sql-0:2.1.19-5.EL4.i386
dovecot-0:0.99.11-4.EL4.i386
freeradius-postgresql-0:1.0.1-3.RHEL4.3.i386
libdbi-dbd-pgsql-0:0.6.5-10.RHEL4.1.i386
mod_auth_pgsql-0:2.0.1-7.1.i386
perl-DBD-Pg-0:1.31-6.i386
php-pgsql-0:4.3.9-3.22.3.i386
qt-PostgreSQL-1:3.3.3-10.RHEL4.i386


I could see this being a real pain, for instance, if I wanted to do PHP
or Perl work with PostgreSQL, I'd have to replace the RHEL4 version of
PHP with something custom built.




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

John,

On 3/2/07, John R Pierce <pierce@hogranch.com> wrote:
> compat-postgresql-libs-4-2PGDG.rhel4.rpm supplies libpq.so.4 and .4.1,
> but it does NOT include .so.3. I think it should provide a .so.3 which
> can coexist with the rest of the 8.2.3 stack (or, there should be a
> compat-postgresql-libs-3 ?)

Just use this package:
http://developer.postgresql.org/~devrim/rpms/compat/ (and especially
http://developer.postgresql.org/~dev...3PGDG.i686.rpm
as you don't seem to use 64 bits packages)
which includes libpq.so.3. It works well on RHEL4.

FYI, Devrim is the PGDG RPM maintainer.

--
Guillaume

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Hi,

On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote:
> (or, there should be a compat-postgresql-libs-3 ?)

Hmm.

Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend,
to rhel-4 directories; so that people can find that package easily.

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



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBF6CNtpme12CBXnxERAh/JAJ9woqNlv/BYFXi7CSCn5PfFICogbgCfTgfc
0MW4vsvOx7HCLjy/MSXkDMc=
=Bb/p
-----END PGP SIGNATURE-----

Devrim GÃœNDÃœZ wrote:
> Hi,
>
> On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote:
>
>> (or, there should be a compat-postgresql-libs-3 ?)
>>
>
> Hmm.
>
> Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend,
> to rhel-4 directories; so that people can find that package easily.
>
> Regards,
>

hmmmm.

Preparing... ###########################################
[100%]
package compat-postgresql-libs-4-2PGDG.rhel4 (which is newer
than compat-postgresql-libs-3-3PGDG) is already installed


looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist.


# rpm -qil compat-postgresql-libs
Name : compat-postgresql-libs Relocations: (not relocatable)
Version : 4 Vendor: (none)
Release : 2PGDG.rhel4 Build Date: Wed 06 Dec 2006
05:05:19 AM PST
Install Date: Thu 01 Mar 2007 06:14:38 PM PST Build Host:
web.sanalotogar.com
Group : Applications/Databases Source RPM:
compat-postgresql-libs-4-2PGDG.rhel4.src.rpm
Size : 844192 License: BSD
Signature : (none)
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries
Description :
This package provides compatibility libraries
for PostgreSQL >= 8.0.2 and PostgreSQL <=8.1.X
/usr/lib/libpq.so.4
/usr/lib/libpq.so.4.1

# rpm -qilp compat-postgresql-libs-3-3PGDG.i686.rpm
warning: compat-postgresql-libs-3-3PGDG.i686.rpm: V3 DSA signature:
NOKEY, key ID 748f7d0e
Name : compat-postgresql-libs Relocations: (not relocatable)
Version : 3 Vendor: (none)
Release : 3PGDG Build Date: Tue 31 May 2005
05:33:59 AM PDT
Install Date: (not installed) Build Host: tdm.com.tr
Group : Applications/Databases/Interfaces Source RPM:
compat-postgresql-libs-3-3PGDG.src.rpm
Size : 1217072 License: BSD
Signature : DSA/SHA1, Tue 31 May 2005 05:40:12 AM PDT, Key ID
b65f3a3f748f7d0e
Packager : Devrim GUNDUZ <devrim@PostgreSQL.org>
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries.
Description :
This package provides compatibility libraries for PostgreSQL >= 8.0.2.
/usr/lib/libecpg.so.4
/usr/lib/libecpg.so.4.1
/usr/lib/libecpg_compat.so.1
/usr/lib/libecpg_compat.so.1.2
/usr/lib/libpgtypes.so.1
/usr/lib/libpgtypes.so.1.2
/usr/lib/libpq.so.3
/usr/lib/libpq.so.3.1


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Devrim GÃœNDÃœZ wrote:
> Hi,
>
> On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote:
>
>> (or, there should be a compat-postgresql-libs-3 ?)
>>
>
> Hmm.
>
> Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend,
> to rhel-4 directories; so that people can find that package easily.
>


ah! I think thats a good thing. I did not know where to look for this.

thanks, all!




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Hi,

On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote:
> looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist.

Ok, I got lots of complaints about this. I will work on this today and
announce new sets.

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



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQBGHIXApme12CBXnxERArCtAJ9UBl8V9P4TE3NX572emq +0DghfvwCfUiIE
HHRqxnAVywDBytru8IUyZuA=
=/24o
-----END PGP SIGNATURE-----

On 4/11/07, Devrim GÜNDÜZ <devrim@commandprompt.com> wrote:
> On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote:
> > looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist.
>
> Ok, I got lots of complaints about this. I will work on this today and
> announce new sets.

It's not a real problem IMHO. AFAIR the compat RPMs were designed to
provide a compatibility layer between newer versions of PostgreSQL and
the distribution standard packages and you won't have both libpq
versions used by the distro.

It's probably easy to fix it but I don't think it's so important. At
least it doesn't prevent anyone to have a working system.

--
Guillaume

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Hi,

On Wed, 2007-04-11 at 01:10 -0700, John R Pierce wrote:

> well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system
> that also has, say, RH's build of Apache + PHP + PG access, as thats
> linked to the -3 libraries

Uh? So installing only compat-3 and PostgreSQL 8.2.3 doesn't work?

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



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQBGHJqJpme12CBXnxERAiNKAJ4oZhTN5DDAPdXnDUU8k0 IXnBogcgCdHIb5
xqBMprcrbs+ACEXUyy06Kys=
=r5O2
-----END PGP SIGNATURE-----

On 4/11/07, John R Pierce <pierce@hogranch.com> wrote:
> I think what -I- ran into was that there was no compat-3 in the public
> repositories, just compat-4... this was about a month ago. devrim
> indicated he was going to upload compat-3, and showed me where to find
> it, but I'd already installed compat-4, so -3 refused to install.
>
> on the grounds that there are undoutablly software out there which WAS
> linked with libpq.so.4, it seems to me there should just be one
> compat-postgresql-libs RPM which provides both 3 and 4 and coexists with
> current 8.2.3 rpms.

There's no software linked with libpq.so.4 on standard RHEL 4. They
are all built on libpq.so.3.
IMHO, your problem is that it seems to the RPM database that compat 4
is newer than compat. I think we should have 2 different packages with
different names compat-3 and compat-4.

But you only need the compat package with libpq.so.3 to install 8.1
and 8.2 on RHEL 4.

--
Guillaume

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings