X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E94373A5CF0 for ; Wed, 26 Jan 2005 19:51:37 +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 50733-09 for ; Wed, 26 Jan 2005 19:51:32 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 369EB3A5CE6 for ; Wed, 26 Jan 2005 19:51:32 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j0QJpQDl015649 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 26 Jan 2005 12:51:28 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j0QJpPN8084238; Wed, 26 Jan 2005 12:51:25 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j0QJpPll084237; Wed, 26 Jan 2005 12:51:25 -0700 (MST) (envelope-from mfuhr) Date: Wed, 26 Jan 2005 12:51:25 -0700 From: Michael Fuhr To: James Gunzelman Cc: pgsql-performance@postgresql.org Subject: Re: Upgrading from from 7.4.2 to 8.0 Message-ID: <20050126195125.GA84102@winnie.fuhr.org> References: <9697D58F4D8FF94892AF75A0A5D8CCCC01C1EE5B@OMU-EXCH1.solutionary.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9697D58F4D8FF94892AF75A0A5D8CCCC01C1EE5B@OMU-EXCH1.solutionary.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/512 X-Sequence-Number: 10202 On Wed, Jan 26, 2005 at 12:51:14PM -0600, James Gunzelman wrote: > Will I have to dump and reload all my databases when migrating from > 7.4.2 to 8.0? Yes -- the Release Notes mention it under "Migration to version 8.0": http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0 Those unfamiliar with doing an upgrade might want to read "If You Are Upgrading" in the "Installation Instructions" chapter of the documenation, and "Migration Between Releases" in the "Backup and Restore" chapter: http://www.postgresql.org/docs/8.0/static/install-upgrading.html http://www.postgresql.org/docs/8.0/static/migration.html (Install or upgrade questions should probably go to pgsql-admin or pgsql-general instead of pgsql-performance.) -- Michael Fuhr http://www.fuhr.org/~mfuhr/