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