From raul@zerosoft.ro Tue Mar 23 10:45:29 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 22016D1DC5D for ; Tue, 23 Mar 2004 10:45:29 +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 87576-06 for ; Tue, 23 Mar 2004 06:45:29 -0400 (AST) Received: from mail.zerosoft.ro (main.zerosoft.ro [193.226.89.14]) by svr1.postgresql.org (Postfix) with ESMTP id C98F5D1DBAF for ; Tue, 23 Mar 2004 06:45:18 -0400 (AST) Received: from 192.168.16.10 by mail.zerosoft.ro ([192.168.16.1] running VPOP3) with SMTP for ; Tue, 23 Mar 2004 12:55:38 +0200 Message-ID: <001301c410c5$60c10240$0a10a8c0@zerosoft.ro> Reply-To: "Raul Secan" From: "Raul Secan" To: Subject: upgrading to 7.4.2 Date: Tue, 23 Mar 2004 12:55:39 +0200 Organization: ZEROSOFT MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0010_01C410D6.24423120" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Server: VPOP3 V1.4.5 - Registered to: ZeroSoft X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200403/55 X-Sequence-Number: 2654 This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C410D6.24423120 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, can anyone tell me the exact steps to upgrading from 7.4.1 to 7.4.2. I didn't upgrade PostgreSQL until now, but I need to do that now, so I don'= t want to brake something. Thanks, Raul Secan. ------=_NextPart_000_0010_01C410D6.24423120 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello, can anyone tell me the exact steps = to=20 upgrading from 7.4.1 to 7.4.2.
I didn't upgrade PostgreSQL until now, but= I need=20 to do that now, so I don't want to brake something.
 
Thanks, Raul Secan.
------=_NextPart_000_0010_01C410D6.24423120-- From bruno@wolff.to Tue Mar 23 15:47:40 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8609FD1C4EB for ; Tue, 23 Mar 2004 15:47:40 +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 18462-09 for ; Tue, 23 Mar 2004 11:47:42 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 00A65D1B97B for ; Tue, 23 Mar 2004 11:47:37 -0400 (AST) Received: (qmail 23201 invoked by uid 500); 23 Mar 2004 15:50:41 -0000 Date: Tue, 23 Mar 2004 09:50:41 -0600 From: Bruno Wolff III To: Raul Secan Cc: pgsql-php@postgresql.org Subject: Re: upgrading to 7.4.2 Message-ID: <20040323155041.GA22109@wolff.to> Mail-Followup-To: Raul Secan , pgsql-php@postgresql.org References: <001301c410c5$60c10240$0a10a8c0@zerosoft.ro> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <001301c410c5$60c10240$0a10a8c0@zerosoft.ro> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/56 X-Sequence-Number: 2655 On Tue, Mar 23, 2004 at 12:55:39 +0200, Raul Secan wrote: > Hello, can anyone tell me the exact steps to upgrading from 7.4.1 to 7.4.2. > I didn't upgrade PostgreSQL until now, but I need to do that now, so I don't want to brake something. Pretty much you just need to shutdown the database before installing the new binaries. You don't have to do a dump and restore. However, you want to read the 7.4.2 release notes as a dump, initdb and restore may be the easiest way for you to fix one of the problems fixed in 7.4.2. From bruno@wolff.to Wed Mar 24 17:23:11 2004 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.