Re: Easy upgrade on Cpanel *without* downtime

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
Cc: "Tino Wildenhain" <tino(at)wildenhain(dot)de>, "Andrew Sullivan" <ajs(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Easy upgrade on Cpanel *without* downtime
Date: 2008-08-26 02:36:34
Message-ID: dcc563d10808251936k5080ee75ua4ae4fe64d318dbc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 25, 2008 at 7:25 PM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
>> > If you're going to run slony, then the pg_dump|pg_restore step is
>> > completely wasted. Slony will restore all the data again. You do
>> > need to run pg_dump -s, of course.
>
>
>
>
> Thanks to everyone who replied. We have no experience with this
> "Slony". Any simple instructions on installing it and getting it
> working?
>
> Why is PG so complex! It's a such a lovely database. If only at least
> the installation and upgrade could be made more humane..

Any database that has real ACID guarantees is going to be complex.
Some more than others. I think that upgrading postgresql in place is
a LOT of work and not the highest priority, and slony lets you upgrade
LIVE. Note that you cannot upgrade an Oracle installation from 9g to
10i live. You take it offline from the app, migrate your data, and
start up the new database.

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-08-26 02:41:40 Re: Trigger function is not called
Previous Message Bill 2008-08-26 02:32:09 Re: Trigger function is not called