Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C07179FB4B7 for ; Fri, 23 Feb 2007 15:07:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 86703-04 for ; Fri, 23 Feb 2007 15:07:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id C78409FB2D6 for ; Fri, 23 Feb 2007 15:07:45 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l1NJ7N716217; Fri, 23 Feb 2007 14:07:23 -0500 (EST) From: Bruce Momjian Message-Id: <200702231907.l1NJ7N716217@momjian.us> Subject: Re: should we have a separate page that clearly defines what a minor release is and why it's a good idea to keep up with them? In-Reply-To: <20070221200138.GA9506@wolff.to> To: Bruno Wolff III Date: Fri, 23 Feb 2007 14:07:23 -0500 (EST) CC: Magnus Hagander , Andrew Hammond , pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.082 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/37 X-Sequence-Number: 4168 I have again updated the FAQ to mention the major/minor release numbering:

3.6) What is the upgrade process for PostgreSQL?

PostgreSQL major releases include new features and occur roughly once every year. A major release is numbered by increasing either the first or second part of the version number, e.g. 8.1 to 8.2.

Major releases usually change the internal format of system tables and data files. These changes are often complex, so we don't maintain backward compatibility for data files. A dump/reload of the database is required for major upgrades.

Minor releases are numbered by increasing the third part of the version number, e.g. 8.1.5 to 8.1.6. The PostgreSQL team only adds bug fixes to minor releases. All users should upgrade to the most recent minor release as soon as possible. While upgrades always have some risk, PostgreSQL minor releases fix only frequently-encountered, security, and data corruption bugs to reduce the risk of upgrading. The community considers not upgrading riskier than upgrading.

`

Upgrading to a minor release does not does not require a dump and restore; merely stop the database server, install the updated binaries, and restart the server.

--------------------------------------------------------------------------- Bruno Wolff III wrote: > On Wed, Feb 21, 2007 at 10:07:22 -0500, > Bruce Momjian wrote: > > > >

All users should upgrade to the most recent minor release as soon > > as it is available. While upgrades always have some risk, PostgreSQL > > minor releases fix only common bugs to reduce the risk of upgrading. > > The community considers not upgrading more risky that > > upgrading.

> > > > What should change about this text? > > The "soon as available" seems to be too aggressive to me. This seems to > suggest (to me at least) that these upgrades are so important that you > might want to skimp on QA to get them in place rapidly. While that may > sometimes be true, I don't think it is always the case for everybody. -- Bruce Momjian http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +