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 3F5F89DCCD2 for ; Fri, 10 Feb 2006 06:18:15 -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 48487-01 for ; Fri, 10 Feb 2006 06:18:16 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id BBADE9DCCA7 for ; Fri, 10 Feb 2006 06:18:12 -0400 (AST) Received: from laptop.thirdspace.tv (unknown [195.166.116.245]) by svr4.postgresql.org (Postfix) with ESMTP id 2CF065AF180 for ; Fri, 10 Feb 2006 10:18:15 +0000 (GMT) Received: from [127.0.0.1] (laptop.kieser2.demon.co.uk [127.0.0.1]) by laptop.thirdspace.tv (Postfix) with ESMTP id F2EC4CC5B9; Fri, 10 Feb 2006 10:16:08 +0000 (GMT) Message-ID: <43EC67E8.2030402@kieser.net> Date: Fri, 10 Feb 2006 10:16:08 +0000 From: Bradley Kieser User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: =?UTF-8?B?RG9taW5payBTa8WCYWRhbm93c2tp?= Cc: pgsql-admin@postgresql.org Subject: Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200602/99 X-Sequence-Number: 20520 Dominik Składanowski wrote: > Hello list, > > Bradley Kieser wrote: > >> I would always use the latest stable release from the PG project for >> four reasons: >> a) Databases are notoriously difficult to upgrade once they are in [ ... ] >> >> b) The dev team just keeps on making this wonderful DB better. Every >> release is a gem and well worth having. >> >> c) PG runs on RedHat no problems. Besides which, in the real world, if [ ... ] >> >> d) Most importantly: You WILL be testing the new PG release in addition [ ... ] >> > > Your arguments convinced me to use latest stable PostgreSQL database. > I use CentOS 4.x (as you know it is RHEL4 compatibile) and I have > successfuly installed PostgreSQL 8.1.2 from www.postgresql.org. > > Cool. Hope you are very happy with the decision. > And now, if I need PostgreSQL as a base for PHP aplication? Package > php-pgsql-4.3.9-3.9.rpm (distributed with CentOS/RHEL) will be works > with PostgreSQL 8.1.2? > > I am not familiar with that particular RPM so can't comment, unfortunately. But in general, I have found that all the php-pgsql rpms work with the PG 8.x releases. I have not yet had any problems. Maybe someone else on the list knows of any problems? Beware thought, of older PHP4 releases as there was a fairly nasty bug in the IMAP handling. > Regards > -- > __________________________________________________________________ > D o m i n i k S k ł a d a n o w s k i > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >