Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 058DA9FB47F; Mon, 23 Apr 2007 23:16:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 49706-08; Mon, 23 Apr 2007 23:16:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by postgresql.org (Postfix) with ESMTP id CED799FB395; Mon, 23 Apr 2007 23:16:11 -0300 (ADT) Received: from new-host.home ([71.166.59.121]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JGZ00EQECYTFAU2@vms044.mailsrvcs.net>; Mon, 23 Apr 2007 21:16:06 -0500 (CDT) Date: Mon, 23 Apr 2007 22:15:59 -0400 From: Robert Treat Subject: Re: Postgresql Help In-reply-to: <462C425B.7090802@sifycorp.com> To: pgsql-admin@postgresql.org Cc: Mageshwaran , Bruce Momjian , pgsql-general@postgresql.org Message-id: <200704232216.00234.robert@omniti.com> Organization: OmniTI MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <462C425B.7090802@sifycorp.com> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/222 X-Sequence-Number: 25286 On Monday 23 April 2007 01:21, Mageshwaran wrote: > Hi , > > I am new to postgresql, I have been assigned a task of upgrading > postgresql to higher version. > In our company we are using 7.1.1,7.1.3,7.4.5 versions of postgresql, > can you please tell me which is the stable and suitable version in 8.x > version. > If you plan to do your upgrades within the next 4 months, you'll want to target 8.2.4. If you plan to upgrade after that, then 8.3 is the version you'll want (it is currently expected to be released around July). You should be aware that upgrading from 7.1.x versions is likely to be a somewhat intensive process since, while it should be backwards compatible, recent versions of pg_dump almost certainly hasn't recieved much testing against 7.1.x versions. (I'd almost recommend upgrading to an intermediate version like 7.4.x, but it probably isn't worth it... just make sure that you keep a copy of your 7.1 databases running until your done testing, and make sure to test your applications thoroughly. Also don't forget that any applications /drivers/ libraries that are built against 7.1 should be updated / recompiled against newer versions as well. HTH. -- Robert Treat Database Architect OmniTI Technology Firm http://www.omniti.com/