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 |
Thread: | |
Lists: | 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!
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 |