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 51B883B4861 for ; Wed, 15 Dec 2004 15:57:01 +0000 (GMT) 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 80932-05 for ; Wed, 15 Dec 2004 15:56:47 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id CE9B73B4848 for ; Wed, 15 Dec 2004 15:56:47 +0000 (GMT) Received: (qmail 19996 invoked by uid 500); 15 Dec 2004 16:09:32 -0000 Date: Wed, 15 Dec 2004 10:09:32 -0600 From: Bruno Wolff III To: Tsirkin Evgeny Cc: pgsql-admin@postgresql.org Subject: Re: upgrading postgresql Message-ID: <20041215160932.GB13637@wolff.to> Mail-Followup-To: Tsirkin Evgeny , pgsql-admin@postgresql.org References: <41C00963.7090904@mail.jct.ac.il> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41C00963.7090904@mail.jct.ac.il> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/139 X-Sequence-Number: 15725 On Wed, Dec 15, 2004 at 11:52:35 +0200, Tsirkin Evgeny wrote: > Hi all! > We are currently running a 7.3.4 backed and planning to upgrade. > However we can't do to much/at all changes in the applications using the db. > So the question is to what version to upgrade : > what is the best release from the 7.3.* ? The one with the highest number in the third position. You can check the download sites to see what versions are available. If you have to use something supported by your OS vendor than you may have more limited options. > would the upgrade to 7.4.* require serious changes in the applications , > if not what is the > best release of the 7.4.*? You would have to do a dump and reload to go to the 7.4 series. I don't think there is too much else that would cause a problem, but you should read the release notes to double check that there isn't anything that will cause you problems. > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings