Re: reduce downtime when upgrading 7.3 -> 7.4 - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: reduce downtime when upgrading 7.3 -> 7.4
Date
Msg-id 20040212220626.GB905@phlogiston.dyndns.org
Whole thread Raw
In response to Re: reduce downtime when upgrading 7.3 -> 7.4  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-admin
On Sat, Feb 07, 2004 at 11:30:59PM -0500, Christopher Browne wrote:
>
> A "faster" method would be to use one of the replication systems, such
> as ERserv.
>
> You have your existing database, running 7.3.4, and set up another DB
> instance (perhaps on the same box) running 7.4.1.

Note that adding replication to an existing, non-replicated database
is some amount of work and imposes some overhead on your system.

> All that being said, ERserv may not cope perfectly with BLOBs, so you
> may need to do something special about that.

It copes very badly with them, in fact, as its memory is limited by
the JVM limits.

The strategy is otherwise sound, though, and has even been used by,
uh, some of us.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

pgsql-admin by date:

Previous
From: Bjoern Metzdorf
Date:
Subject: Re: No space left on device
Next
From: Steve Crawford
Date:
Subject: Re: hanging for 30sec when checkpointing