Skip site navigation (1) Skip section navigation (2)

Re: 7.4 --> 8.0/8.1 upgrade

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: 7.4 --> 8.0/8.1 upgrade
Date: 2006-03-30 23:08:28
Message-ID: 60ek0jpm37.fsf@dba2.int.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-admin
jnasby(at)pervasive(dot)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(at)~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

In response to

pgsql-admin by date

Next:From: Mark LibermanDate: 2006-03-31 00:04:04
Subject: Re: Release plans for improvements to partitioning
Previous:From: Jim NasbyDate: 2006-03-30 22:07:19
Subject: Re: export of schema only

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group