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 1E5C611F61D7 for ; Tue, 28 Mar 2006 23:00:48 -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 07533-01 for ; Tue, 28 Mar 2006 23:00:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.travelamericas.com (unknown [206.130.134.147]) by postgresql.org (Postfix) with SMTP id D13A511F600C for ; Tue, 28 Mar 2006 23:00:33 -0400 (AST) Received: (qmail 19707 invoked from network); 29 Mar 2006 03:00:33 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 29 Mar 2006 03:00:33 -0000 Message-ID: <4429F850.1000302@metatrontech.com> Date: Tue, 28 Mar 2006 19:00:32 -0800 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Scott Marlowe CC: sh test , pgsql-admin@postgresql.org Subject: Re: 7.4 --> 8.0/8.1 upgrade References: <20060329014729.64497.qmail@web37502.mail.mud.yahoo.com> <1143597318.3625.123.camel@state.g2switchworks.com> In-Reply-To: <1143597318.3625.123.camel@state.g2switchworks.com> Content-Type: multipart/mixed; boundary="------------060601080105050900060102" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.113 required=5 tests=[AWL=0.113] X-Spam-Score: 0.113 X-Spam-Level: X-Archive-Number: 200603/332 X-Sequence-Number: 21089 This is a multi-part message in MIME format. --------------060601080105050900060102 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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. 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. Best Wishes, Chris Travers Metatron Technology Consulting --------------060601080105050900060102 Content-Type: text/x-vcard; charset=utf-8; name="chris.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="chris.vcf" begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com tel;work:509-888-0220 tel;cell:509-630-7794 x-mozilla-html:FALSE version:2.1 end:vcard --------------060601080105050900060102--