Easy upgrade on Cpanel *without* downtime

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Easy upgrade on Cpanel *without* downtime
Date: 2008-08-25 09:21:17
Message-ID: e373d31e0808250221t1c4dd4c6m7501376a88615c0e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general


I have googled and googled for good, simple instructions to upgrade
from 8.2.3 to 8.3.3 (latest stable at this time?)

I am on a Cpanel interface. Use Apache and PHP for most of my websites.

This seems to be the most often quoted resource on forums etc:


But this suggests backing up, then UNinstalling (downtime and loss of
settings!), then REinstalling postgresql.

Is there no sensible way of simply upgrading the database engine
without affecting either the uptime or the data itself?

I really really do not wish to backup gigabytes worth of data and then
reupload it back into the DB. This represents a downtime of *at least*
an hour or so, which our busy website doesn't have.

Any thoughts or pointers?



Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2008-08-25 09:34:00 Re: Easy upgrade on Cpanel *without* downtime
Previous Message Ivan Sergio Borgonovo 2008-08-25 07:14:38 playing with catalog tables limits? dangers? was: seq bug 2073 and time machine