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 A14D13A578F for ; Wed, 26 Jan 2005 20:14:48 +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 54144-04 for ; Wed, 26 Jan 2005 20:14:41 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 333843A572C for ; Wed, 26 Jan 2005 20:14:41 +0000 (GMT) Received: (qmail 1968 invoked from network); 26 Jan 2005 20:14:40 -0000 Received: from w080.z064003242.bna-tn.dsl.cnc.net (HELO ?192.168.1.22?) (64.3.242.80) by 0 with SMTP; 26 Jan 2005 20:14:40 -0000 In-Reply-To: <20050126195125.GA84102@winnie.fuhr.org> References: <9697D58F4D8FF94892AF75A0A5D8CCCC01C1EE5B@OMU-EXCH1.solutionary.com> <20050126195125.GA84102@winnie.fuhr.org> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <9a5a0440c005682cf2963293f6fc779d@sitening.com> Content-Transfer-Encoding: 7bit Cc: pgsql-performance@postgresql.org, James Gunzelman From: Thomas F.O'Connell Subject: Re: Upgrading from from 7.4.2 to 8.0 Date: Wed, 26 Jan 2005 14:14:35 -0600 To: Michael Fuhr X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.24 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200501/514 X-Sequence-Number: 10204 It should be noted that users who use Slony can create a subscriber node running 8.0 that subscribes to a node running 7.4.x and can transition with only the downtime required for failover. This obviates the need for a dump/restore. See . -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Jan 26, 2005, at 1:51 PM, Michael Fuhr wrote: > 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/