jnasby@xxxxxxxxxxxxx (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
