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
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