Re: Easy upgrade on Cpanel *without* downtime - Mailing list pgsql-general

From Robert Gobeille
Subject Re: Easy upgrade on Cpanel *without* downtime
Date
Msg-id B948D45C-0C7D-40A6-BA9B-22D935F44135@hp.com
Whole thread Raw
In response to Re: Easy upgrade on Cpanel *without* downtime  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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.kiula@gmail.com
> > wrote:
>> On 8/26/08, Scott Marlowe <scott.marlowe@gmail.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

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: Easy upgrade on Cpanel *without* downtime
Next
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: web form development ide/api..