X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 39D5253475 for ; Mon, 11 Apr 2005 03:26:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02887-07 for ; Mon, 11 Apr 2005 06:26:00 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 62DC95295A for ; Mon, 11 Apr 2005 03:25:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3B6PwXS022299; Mon, 11 Apr 2005 02:25:58 -0400 (EDT) To: Michael Fuhr Cc: goa , pgsql-admin@postgresql.org Subject: Re: postgres help In-reply-to: <20050411014503.GB4198@winnie.fuhr.org> References: <20050409094601.85281.qmail@web42109.mail.yahoo.com> <20050411014503.GB4198@winnie.fuhr.org> Comments: In-reply-to Michael Fuhr message dated "Sun, 10 Apr 2005 19:45:03 -0600" Date: Mon, 11 Apr 2005 02:25:58 -0400 Message-ID: <22298.1113200758@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/132 X-Sequence-Number: 17145 Michael Fuhr writes: > On Sat, Apr 09, 2005 at 02:46:01AM -0700, goa wrote: >> We had developed some apllication with postgres-7.0.3-8 as back end >> now that we have upgraded all our servers to redhat9.0,also we cannot >> use new version of postgres since there is some issues with date fields >> which we use of postgres-7.0 > Could you elaborate on those issues? 7.0.3 is over four years > old -- aside from new functionality in later releases, there have > been numerous bug fixes since then. You really should consider > using a newer version; I'm sure the people on these lists would be > willing to help solve whatever problems that might cause. The oldest version that the community considers even slightly supported is 7.2.*. 7.1.* and before have fundamental, unfixable data-loss risks (for instance, after 4 billion transactions you WILL lose all your data in 7.0.*). So you would be far better advised to spend your effort on fixing your application to make it play with a current PG release than on trying to recompile such an ancient release. BTW, with my Red Hat hat on, I would say that RHL9 is about equally obsolete. Why aren't you updating to a more modern platform, if you're troubling to update at all? regards, tom lane