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 2826111F6627 for ; Wed, 29 Mar 2006 05:32:57 -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 80136-04 for ; Wed, 29 Mar 2006 05:32:56 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E9C0511F65E4 for ; Wed, 29 Mar 2006 05:32:54 -0400 (AST) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr4.postgresql.org (Postfix) with ESMTP id 0084F5AF04E for ; Wed, 29 Mar 2006 09:32:54 +0000 (GMT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1FOX2e-0004I8-0f for pgsql-admin@postgresql.org; Wed, 29 Mar 2006 11:32:40 +0200 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 29 Mar 2006 11:32:40 +0200 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 29 Mar 2006 11:32:40 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: 7.4 --> 8.0/8.1 upgrade Date: Wed, 29 Mar 2006 12:32:31 +0300 Lines: 46 Message-ID: References: <20060329014729.64497.qmail@web37502.mail.mud.yahoo.com> <1143597318.3625.123.camel@state.g2switchworks.com> <4429F850.1000302@metatrontech.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Mozilla Thunderbird 1.5 (Windows/20051201) In-Reply-To: <4429F850.1000302@metatrontech.com> 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/333 X-Sequence-Number: 21090 Chris Travers написа: > 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. >> Upside: Everything else. PostgreSQL 8.x series has a lot of >> performance improvements. >> >> > When I upgraded from 7.4.2 to 8.1.3, I lost the oid fields in some > tables which caused some issues with one application. Probably because in 8.1 the value for the "default_with_oids" parameter is "false". If you had tried to set it to "true" (at least for duration of the restore) then you would have not lost those OIDs. > > I suspect that the better path is to upgrade (without dump/reload) to > the most recent 7.4 release and then dump/reload when upgrading to 8.1.x > but I am not 100% sure. > > If you don't WANT OID's in your table (they were dropped for a reason, > you know), then this is not a concern. -- Milen A. Radev