X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A31A511F6623 for ; Thu, 30 Mar 2006 18:01:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63858-02 for ; Thu, 30 Mar 2006 18:01:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id B446311F6669 for ; Thu, 30 Mar 2006 18:01:14 -0400 (AST) Received: from [172.16.5.98] (64-132-13-2.gen.twtelecom.net [64.132.13.2]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 12C1756408; Thu, 30 Mar 2006 16:01:10 -0600 (CST) In-Reply-To: <1143597318.3625.123.camel@state.g2switchworks.com> References: <20060329014729.64497.qmail@web37502.mail.mud.yahoo.com> <1143597318.3625.123.camel@state.g2switchworks.com> Mime-Version: 1.0 (Apple Message framework v746.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <73DB982A-00F0-42BE-8CC3-EA111F6A88B3@pervasive.com> Cc: sh test , pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: 7.4 --> 8.0/8.1 upgrade Date: Thu, 30 Mar 2006 16:01:07 -0600 To: Scott Marlowe X-Mailer: Apple Mail (2.746.3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200603/391 X-Sequence-Number: 21148 On Mar 28, 2006, at 7:55 PM, Scott Marlowe wrote: > On Tue, 2006-03-28 at 19:47, sh test wrote: >> Hello admins! >> >> i need to collect as much information >> >> pro/cons on a possible upgrade from >> >> 7.4 ---> 8.0/8.1 version >> >> Aside from getting our users vote on this, I wanted to ask you first >> in order to collect any possible issues one might run into from >> upgrading to such >> versions. > > Downside: You gotta dump and reload, or use slony to minimize the > downtime, but you need a spare machine to do that. Actually, there's no reason you shouldn't be able to use slony to upgrade on the same machine, provided that machine has enough resources to run two installs of PostgreSQL and the databases simultaneously. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461