Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 86C689FB8BB for ; Wed, 11 Apr 2007 14:53:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 63027-04 for ; Wed, 11 Apr 2007 14:53:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from smtp106.sbc.mail.re2.yahoo.com (smtp106.sbc.mail.re2.yahoo.com [68.142.229.99]) by postgresql.org (Postfix) with SMTP id 0B7669FB8D2 for ; Wed, 11 Apr 2007 14:53:35 -0300 (ADT) Received: (qmail 63925 invoked from network); 11 Apr 2007 17:53:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type:X-Priority:X-MSMail-Priority:X-Mailer:In-Reply-To:x-mimeole:Importance; b=AYxsk8tpEjAsxNCkdg3fSlmi+tQB9DW1xVR87Rdx0+SMG3f9Kyxgfh8bHPSSV27/EPUxDwX6wW3uVLkKZ9pj9Djxv5mDV4iyPp9sLvg4113m8tfxyV4CADsrTcYDODZ7zjay3qVL1708fA0vt6uT8bYtVu/wpcd5b3v8m/twL5g= ; Received: from unknown (HELO dualcore) (adam.r@sbcglobal.net@68.251.67.17 with login) by smtp106.sbc.mail.re2.yahoo.com with SMTP; 11 Apr 2007 17:53:34 -0000 X-YMail-OSG: pWZhKgEVM1nIYJGTeucCYkjdQ_HdAZcehN9eBtgfiR7imfuN8gufr1.DvL1UBHclM5KE3U0cGXsX9w8E_8IBsrZUjO2pXRWgOebIvDpo9r.2tg4fxF6CE006N9RZref0cIVC3vLxfrnMmp6vllVUpVhFYg-- From: "Adam Rich" To: "'Michael Dengler'" , =?iso-8859-1?Q?'Devrim_G=DCND=DCZ'?= Cc: "'pgsql-performance'" , "'Guillaume Smet'" Subject: Re: Do I need to rebuild php-pgsql for 8.2.3 Date: Wed, 11 Apr 2007 12:53:39 -0500 Message-ID: <070f01c77c62$561c1a30$6400a8c0@dualcore> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0710_01C77C38.6D461230" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: x-mimeole: Produced By Microsoft MimeOLE V6.00.3790.2826 Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/241 X-Sequence-Number: 24118 This is a multi-part message in MIME format. ------=_NextPart_000_0710_01C77C38.6D461230 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Here's what I do...=20 =20 1) Install postgresql-libs from the RHEL source 2) Install compat-postgresql-libs from postgresql.org (install, not upgrade, use rpm -hiv) use force if necessary 3) Install postgresq-libs from postgresql.org (again, install, not upgrade, use rpm-hiv) use force if necessary =20 If done correctly, you'll end up with all 3 client versions: =20 /usr/lib/libpq.so.3 /usr/lib/libpq.so.4 /usr/lib/libpq.so.5 =20 =20 -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Michael Dengler Sent: Wednesday, April 11, 2007 12:25 PM To: Devrim G=DCND=DCZ Cc: pgsql-performance; Guillaume Smet Subject: Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3 Hi, Thanks for the info. One more thing....I am in rpm hell. When I try to=20 # rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm I get: error: Failed dependencies: libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386 libpq.so.3 is needed by (installed) postgresql-python-7.4.13-2.RHEL4.1.i386 libpq.so.3 is needed by (installed) php-pgsql-4.3.9-3.15.i386 and when I try: # rpm -ivh compat-postgresql-libs-3-3PGDG.i686.rpm=20 I get: error: Failed dependencies: postgresql-libs < 8.0.2 conflicts with compat-postgresql-libs-3-3PGDG.i686 grrrrr... should just force the upgrade (ie. --nodeps)? Thanks Mike On 4/10/07, Devrim G=DCND=DCZ wrote:=20 Hi, On Tue, 2007-04-10 at 22:55 +0200, Guillaume Smet wrote: > See http://developer.postgresql.org/~devrim/rpms/compat/ and choose > the correct package for your architecture.=20 ... or better, each RHEL4 directory in our FTP site has compat package (that directory is not up2date now). Regards, -- Devrim G=DCND=DCZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support=20 Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ ------=_NextPart_000_0710_01C77C38.6D461230 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
Here's=20 what I do...
 
1)=20 Install postgresql-libs from the RHEL source
2)=20 Install compat-postgresql-libs from postgresql.org (install, not = upgrade, use=20 rpm -hiv) use force if necessary
3)=20 Install postgresq-libs from postgresql.org (again, install, not upgrade, = use=20 rpm-hiv) use force if necessary
 
If=20 done correctly, you'll end up with all 3 client = versions:
 
/usr/lib/libpq.so.3
/usr/lib/libpq.so.4
/usr/lib/libpq.so.5
 
 
=
-----Original Message-----
From:=20 pgsql-performance-owner@postgresql.org=20 [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of = Michael=20 Dengler
Sent: Wednesday, April 11, 2007 12:25 = PM
To:=20 Devrim G=DCND=DCZ
Cc: pgsql-performance; Guillaume=20 Smet
Subject: Re: [PERFORM] Do I need to rebuild php-pgsql = for=20 8.2.3

Hi,

Thanks for the info. One more = thing....I=20 am in rpm hell. When I try to
# rpm -Uvh=20 postgresql-libs-8.2.3-1PGDG.i686.rpm
I get:
error: Failed=20 dependencies:
        libpq.so.3 = is=20 needed by (installed)=20 perl-DBD-Pg-1.31-6.i386
       =20 libpq.so.3 is needed by (installed)=20 = postgresql-python-7.4.13-2.RHEL4.1.i386
     =   =20 libpq.so.3 is needed by (installed) php-pgsql-4.3.9-3.15.i386
and = when I=20 try:
# rpm -ivh compat-postgresql-libs-3-3PGDG.i686.rpm
I=20 get:
error: Failed=20 dependencies:
        = postgresql-libs=20 < 8.0.2 conflicts with=20 compat-postgresql-libs-3-3PGDG.i686
grrrrr...
should just force = the=20 upgrade (ie. --nodeps)?

Thanks

Mike


On 4/10/07, Devrim=20 G=DCND=DCZ <devrim@commandprompt.com>= =20 wrote:
Hi,

On=20 Tue, 2007-04-10 at 22:55 +0200, Guillaume Smet wrote:
> See http://deve= loper.postgresql.org/~devrim/rpms/compat/=20 and choose
> the correct package for your architecture. =

... or=20 better, each RHEL4 directory in our FTP site has compat = package
(that=20 directory is not up2date now).

Regards,
--
Devrim=20 G=DCND=DCZ
PostgreSQL Replication, Consulting, Custom = Development, 24x7=20 support
Managed Services, Shared and Dedicated = Hosting
Co-Authors:=20 plPHP, ODBCng - http://www.commandprompt.com/<= BR>



------=_NextPart_000_0710_01C77C38.6D461230--