X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CCCAFD1D249 for ; Thu, 12 Feb 2004 22:06:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 22056-05 for ; Thu, 12 Feb 2004 18:06:29 -0400 (AST) Received: from fep01-mail.bloor.is.net.cable.rogers.com (fep01-mail.bloor.is.net.cable.rogers.com [66.185.86.71]) by svr1.postgresql.org (Postfix) with ESMTP id F12E1D1D25D for ; Thu, 12 Feb 2004 18:06:25 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep01-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040212220624.JOCK391676.fep01-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Thu, 12 Feb 2004 17:06:24 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 1AF033F3A; Thu, 12 Feb 2004 17:06:26 -0500 (EST) Date: Thu, 12 Feb 2004 17:06:26 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: reduce downtime when upgrading 7.3 -> 7.4 Message-ID: <20040212220626.GB905@phlogiston.dyndns.org> Mail-Followup-To: pgsql-admin@postgresql.org References: <331690000.1076207705@palle.girgensohn.se> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep01-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Thu, 12 Feb 2004 17:06:23 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/188 X-Sequence-Number: 12362 On Sat, Feb 07, 2004 at 11:30:59PM -0500, Christopher Browne wrote: > > A "faster" method would be to use one of the replication systems, such > as ERserv. > > You have your existing database, running 7.3.4, and set up another DB > instance (perhaps on the same box) running 7.4.1. Note that adding replication to an existing, non-replicated database is some amount of work and imposes some overhead on your system. > All that being said, ERserv may not cope perfectly with BLOBs, so you > may need to do something special about that. It copes very badly with them, in fact, as its memory is limited by the JVM limits. The strategy is otherwise sound, though, and has even been used by, uh, some of us. A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner