Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 12BC09FB5ED for ; Wed, 11 Apr 2007 18:47:53 -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 42819-02 for ; Wed, 11 Apr 2007 18:47:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.251]) by postgresql.org (Postfix) with ESMTP id 572CA9FB54B for ; Wed, 11 Apr 2007 18:47:42 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so378055ana for ; Wed, 11 Apr 2007 14:47:41 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=o9dQQCtK9DwO8JpuoLM0LPjwxtM+1TwAeIw5RqLpjNTCPx8YVJuEddTOQcfeFdpsnJlijvuZjI5e+JnR65xC7uXyc9Evj9P9nVPxd6MXvEgUy/HEQgg5YXXtCXrkYDB2i9UoY1h+HFN/01Kvokrjjo4EPqP/Vfeier2/t0mMEFU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Q044sZv1d1nADYojF5q2Zbj4XAFhSmiRrVtMtx9fxwPZ0MpXLCR4pBJ7iWWsph0t17smZcMrmRBaubkfnq2j/WjqdG36iGKReACXUkh5qSSDWLMAh2BF0U641dVJYFbcSPkYI6CKFmpWYGRDFNUz/ec0CJPxL56bTZrL+9z/YLQ= Received: by 10.100.43.9 with SMTP id q9mr836512anq.1176328061237; Wed, 11 Apr 2007 14:47:41 -0700 (PDT) Received: by 10.100.134.10 with HTTP; Wed, 11 Apr 2007 14:47:41 -0700 (PDT) Message-ID: Date: Wed, 11 Apr 2007 17:47:41 -0400 From: "Michael Dengler" To: "Adam Rich" Subject: Re: Do I need to rebuild php-pgsql for 8.2.3 Cc: "=?ISO-8859-1?Q?Devrim_G=DCND=DCZ?=" , pgsql-performance , "Guillaume Smet" In-Reply-To: <070f01c77c62$561c1a30$6400a8c0@dualcore> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23823_10305632.1176328061084" References: <070f01c77c62$561c1a30$6400a8c0@dualcore> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/243 X-Sequence-Number: 24120 ------=_Part_23823_10305632.1176328061084 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks...worked perfectly! Mike On 4/11/07, Adam Rich wrote: > > Here's what I do... > > 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 > > If 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:* 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 > # 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 > 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: > > > > 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. > > > > ... 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 > > Managed Services, Shared and Dedicated Hosting > > Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ > > > > > > > > > ------=_Part_23823_10305632.1176328061084 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks...worked perfectly!

Mike


On 4/11/07, Adam Rich <adam.r@sbcglobal.net> wrote:=
Here's=20 what I do...
=  
1)=20 Install postgresql-libs from the RHEL source
2)=20 Install compat-postgresql-libs from postg= resql.org (install, not upgrade, use=20 rpm -hiv) use force if necessary
3)=20 Install postgresq-libs from postgresql.or= g (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-performan= ce-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-li= bs=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@com= mandprompt.com>=20 wrote:
Hi,

On= =20 Tue, 2007-04-10 at 22:55 +0200, Guillaume Smet wrote:
> See http://develo= per.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
(tha= t=20 directory is not up2date now).

Regards,
--
Devrim=20 G=DCND=DCZ
PostgreSQL Replication, Consulting, Custom Development, 2= 4x7=20 support
Managed Services, Shared and Dedicated Hosting
Co-Author= s:=20 plPHP, ODBCng - http://www.co= mmandprompt.com/





------=_Part_23823_10305632.1176328061084--