Re: Easy upgrade on Cpanel *without* downtime

From: RW <postgres(at)tauceti(dot)net>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Easy upgrade on Cpanel *without* downtime
Date: 2008-08-25 09:39:04
Message-ID: 48B27DB8.8050707@tauceti.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Normally we don't use the packages from the distributions. They're
mostly outdated and installation ov two or more versions of Postgres
isn't that easy normally in this case. We've a directory structure which
allows
us to install and startup two or more versions in parallel. I haven't
tried this
but if you have two instances running (one 8.2 and the thoer 8.3)
you can try to install Slony migrating all the data through replication.
When all data is synchronized a shot downtime is needed to switch
between the two versions. Maybe this is a way to go...

Robert

Phoenix Kiula wrote:
> 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!
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-08-25 12:53:15 Re: Easy upgrade on Cpanel *without* downtime
Previous Message Tino Wildenhain 2008-08-25 09:34:00 Re: Easy upgrade on Cpanel *without* downtime