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 49B8B11F6716 for ; Thu, 30 Mar 2006 20:16:35 -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 55183-06 for ; Thu, 30 Mar 2006 20:16:33 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 59E3511F6711 for ; Thu, 30 Mar 2006 20:16:32 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k2V0GQWj038777 for ; Thu, 30 Mar 2006 20:16:27 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k2V03w0K033793 for pgsql-admin@postgresql.org; Thu, 30 Mar 2006 20:03:58 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: 7.4 --> 8.0/8.1 upgrade Date: Thu, 30 Mar 2006 18:08:28 -0500 Organization: cbbrowne Computing Inc Lines: 38 Message-ID: <60ek0jpm37.fsf@dba2.int.libertyrms.com> References: <20060329014729.64497.qmail@web37502.mail.mud.yahoo.com> <1143597318.3625.123.camel@state.g2switchworks.com> <73DB982A-00F0-42BE-8CC3-EA111F6A88B3@pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:iz/bPL/mkcYNrTeNndJzyT+YEWg= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.247 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.193] X-Spam-Score: -1.247 X-Spam-Level: X-Archive-Number: 200603/394 X-Sequence-Number: 21151 jnasby@pervasive.com (Jim Nasby) writes: > 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. And note that the second instance only needs to cope with the update traffic. If the 7.4-based backend is servicing a lot of queries as well, that's load that won't be on the replica. -- (format nil "~S@~S" "cbbrowne" "acm.org") http://www3.sympatico.ca/cbbrowne/lisp.html "When I was a boy of fourteen, my father was so ignorant I could hardly stand to have the old man around. But when I got to be twenty-one, I was astonished at how much the old man had learned in seven years." -- Mark Twain