Re: 7.4 --> 8.0/8.1 upgrade - Mailing list pgsql-admin

From Jim Nasby
Subject Re: 7.4 --> 8.0/8.1 upgrade
Date
Msg-id 73DB982A-00F0-42BE-8CC3-EA111F6A88B3@pervasive.com
Whole thread Raw
In response to Re: 7.4 --> 8.0/8.1 upgrade  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-admin
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.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



pgsql-admin by date:

Previous
From: lmyho
Date:
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl
Next
From: Jim Nasby
Date:
Subject: Re: export of schema only