Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CEEBE9FB2C9 for ; Mon, 29 Jan 2007 10:21:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 70425-04 for ; Mon, 29 Jan 2007 10:21:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 70B649FB29D for ; Mon, 29 Jan 2007 10:21:11 -0400 (AST) Received: from perhan.alvh.no-ip.org (200-126-100-202.bk7-dsl.surnet.cl [200.126.100.202]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l0TEKWSC010389; Mon, 29 Jan 2007 06:20:33 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id EDD2D7C83; Mon, 29 Jan 2007 10:57:00 -0300 (CLST) Date: Mon, 29 Jan 2007 10:57:00 -0300 From: Alvaro Herrera To: Bruce Momjian Cc: Peter Eisentraut , pgsql-docs@postgresql.org, "Thomas F. O'Connell" Subject: Re: 14.4 If You Are Upgrading - Suggested Improvements Message-ID: <20070129135700.GB14134@alvh.no-ip.org> Mail-Followup-To: Bruce Momjian , Peter Eisentraut , pgsql-docs@postgresql.org, "Thomas F. O'Connell" References: <200701270151.05085.peter_e@gmx.net> <200701270127.l0R1Rbr15403@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200701270127.l0R1Rbr15403@momjian.us> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Mon, 29 Jan 2007 06:20:38 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/28 X-Sequence-Number: 4124 Bruce Momjian wrote: > Updated text: > > The internal data storage format typically changes in every major > release of PostgreSQL. Therefore, if you are upgrading > an existing installation that does not have a version number of > &majorversion;.x, you must back up and restore your > data. If you are upgrading from the same major version, the new version > can use your current data files so you should skip the backup and > restore steps below because they are unnecessary. That's better, but I'd suggest using &majorversion;.x in the last sentence as well, instead of "the same major version", because some people does not yet grasp that we refer to "major" as the first two digits, instead thinking that all "7" versions are compatible, and all "8", etc. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.