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

From Phoenix Kiula
Subject Easy upgrade on Cpanel *without* downtime
Date
Msg-id e373d31e0808250221t1c4dd4c6m7501376a88615c0e@mail.gmail.com
Whole thread Raw
Responses Re: Easy upgrade on Cpanel *without* downtime
Re: Easy upgrade on Cpanel *without* downtime
List pgsql-general
Hi.

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:

http://kb.linuxnetworkcare.com/node/21

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?

Thanks!

pgsql-general by date:

Previous
From: Brian Green
Date:
Subject: Installing Postgress 8.3.3
Next
From: Tino Wildenhain
Date:
Subject: Re: Easy upgrade on Cpanel *without* downtime