X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 09C16D1ECB9 for ; Wed, 24 Mar 2004 17:23:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15046-07 for ; Wed, 24 Mar 2004 13:23:07 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 77359D1ECD3 for ; Wed, 24 Mar 2004 13:23:06 -0400 (AST) Received: (qmail 11807 invoked by uid 500); 24 Mar 2004 17:26:08 -0000 Date: Wed, 24 Mar 2004 11:26:08 -0600 From: Bruno Wolff III To: Raul Secan Cc: pgsql-admin@postgresql.org Subject: Re: [PHP] upgrading to 7.4.2 Message-ID: <20040324172608.GB11352@wolff.to> Mail-Followup-To: Raul Secan , pgsql-admin@postgresql.org References: <001301c410c5$60c10240$0a10a8c0@zerosoft.ro> <20040323155041.GA22109@wolff.to> <000701c410f2$775efb60$0a10a8c0@zerosoft.ro> <20040323162112.GA24078@wolff.to> <005301c41177$61c3d160$0a10a8c0@zerosoft.ro> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <005301c41177$61c3d160$0a10a8c0@zerosoft.ro> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/312 X-Sequence-Number: 12881 I am copying this back to the admin list to keep the discussion where more people can comment. (The admin list is more appropiate than the PHP list where your initial questions were posted.) On Wed, Mar 24, 2004 at 10:09:51 +0200, Raul Secan wrote: > What I mean is that this is the only posibility to upgrade Postgres, by > deleting the old one and installing the new one? > > Isn't there an easy way to upgrade this database server (for example MySQL's > upgrade is very easy to do: rpm -Uvh mysql.xxxxx.rpm)? If you have rpms for 7.4.2 you can do the update that way. That just replaces the binaries, it doesn't do anything to the data. That technique will work as long as you are doing an upgrade between two minor releases of the same major release. You have to do a dump first if you are changing major release version. Also you should read the release notes for 7.4.2 as there are some special instructions in this case.