X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8ABD29DC85C for ; Fri, 10 Feb 2006 07:16:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56672-06 for ; Fri, 10 Feb 2006 07:16:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 55B539DC81A for ; Fri, 10 Feb 2006 07:16:36 -0400 (AST) Received: from evim.gunduz.org (dsl.static8121514250.ttnet.net.tr [81.215.14.250] (may be forged)) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k1ABNtRK019063; Fri, 10 Feb 2006 03:23:59 -0800 Subject: Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM From: Devrim GUNDUZ To: Bradley Kieser Cc: Dominik =?iso-8859-2?Q?Sk=B3adanowski?= , "pgsql-admin@postgresql.org" In-Reply-To: <43EC686A.8030509@kieser.net> References: <1139526417.16736.6.camel@evim.gunduz.org> <43EC686A.8030509@kieser.net> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Fri, 10 Feb 2006 12:47:56 +0200 Message-Id: <1139568476.23116.13.camel@evim.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-22) Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.87.1, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Fri, 10 Feb 2006 03:24:04 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.16 required=5 tests=[AWL=0.160] X-Spam-Score: 0.16 X-Spam-Level: X-Archive-Number: 200602/101 X-Sequence-Number: 20522 Hi, On Fri, 2006-02-10 at 10:18 +0000, Bradley Kieser wrote: > For the sake of people like me, can you please explain a little further > why you say that you need these RPMs? > Just out of interest and to increase the resident knowledge pool as I > for one am not aware of any problems so at least one person will learn > from your posting! RHEL 3 and RHEL 4 PHP RPMs are compiled with libpq.so.3 . However, beginning from 8.0.2, libpq was bumped to version 4. So this broke compatibility between the packages from PostgreSQL.org and RHEL PHP. In order to solve that problem, we built a compatibility RPM which installs libpq.so.3 and other libs to your system: # rpm -ql compat-postgresql-libs /usr/lib64/libecpg.so.4 /usr/lib64/libecpg.so.4.1 /usr/lib64/libecpg_compat.so.1 /usr/lib64/libecpg_compat.so.1.2 /usr/lib64/libpgtypes.so.1 /usr/lib64/libpgtypes.so.1.2 /usr/lib64/libpq.so.3 /usr/lib64/libpq.so.3.1 If you use Red Hat's RPMs, you don't have this problem because they provide PostgreSQL 7.4, which satisfies PHP dependency. Here is a sample output from my RHEL 4 (x86_64) home box: # rpm -e compat-postgresql-libs error: Failed dependencies: libpq.so.3()(64bit) is needed by (installed) dovecot-0.99.11-2.EL4.1.x86_64 libpq.so.3()(64bit) is needed by (installed) perl-DBD- Pg-1.31-6.x86_64 libpq.so.3()(64bit) is needed by (installed) php- pgsql-4.3.9-3.9.x86_64 We could not document that well except questions in mailing lists and my PostgreSQL blog, that's my mistake I believe. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/