pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: 7.4 --> 8.0/8.1 upgrade
Date: Thu, 30 Mar 2006 18:08:28 -0500
Message-ID: <60ek0jpm37.fsf@dba2.int.libertyrms.com> (raw)
References: <20060329014729.64497.qmail@web37502.mail.mud.yahoo.com>
	<1143597318.3625.123.camel@state.g2switchworks.com>
	<73DB982A-00F0-42BE-8CC3-EA111F6A88B3@pervasive.com>

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



view thread (7+ messages)

Message-ID: <60ek0jpm37.fsf@dba2.int.libertyrms.com>
Permalink:  ../60ek0jpm37.fsf@dba2.int.libertyrms.com/
Also on:    postgresql.org/message-id/60ek0jpm37.fsf@dba2.int.libertyrms.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: 7.4 --> 8.0/8.1 upgrade
  In-Reply-To: <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> <60ek0jpm37.fsf@dba2.int.libertyrms.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox