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

Re: Easy upgrade on Cpanel *without* downtime

From: Robert Gobeille <bob(dot)gobeille(at)hp(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>,Tino Wildenhain <tino(at)wildenhain(dot)de>,Andrew Sullivan <ajs(at)commandprompt(dot)com>,"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Easy upgrade on Cpanel *without* downtime
Date: 2008-08-26 16:35:26
Message-ID: B948D45C-0C7D-40A6-BA9B-22D935F44135@hp.com (view raw or flat)
Thread:
Lists: pgsql-general
On Aug 26, 2008, at 10:22 AM, Scott Marlowe wrote:

> On Tue, Aug 26, 2008 at 12:10 AM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com 
> > wrote:
>> On 8/26/08, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>>>
>>> Slony replication lets postgresql accomplish this, which is really
>>> quite impressive.  We just upgraded from an 8.1 server to an 8.3
>>> server via slony, and it went smooth as silk.  db downtime was
>>> measured in seconds.
>>
>> Thanks for this Scott. Sounds promising. But where can I find the
>> instructions to install Slony, then install new PG 8.3.3, then start
>> it with similar CONF settings and stuff, then setup the master and
>> slave (which I am not familiar with), and then switch master and  
>> slave
>> when everything is working?
>
> Problem here is that while each piece of the puzzle probably has it's
> own useful instructions, no one has put them all together into one
> document, and the reason for that is choice.  With a choice of

Phoenix, you might want to start with some hands on postgres training  
to quickly get up to speed on slony.  I've used http://www.otg- 
nc.com/ .  They are very good.

Bob

In response to

pgsql-general by date

Next:From: Rodrigo E. De León PlicetDate: 2008-08-26 16:37:25
Subject: Re: web form development ide/api..
Previous:From: Scott MarloweDate: 2008-08-26 16:22:31
Subject: Re: Easy upgrade on Cpanel *without* downtime

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