Re: reduce downtime when upgrading 7.3 -> 7.4

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: reduce downtime when upgrading 7.3 -> 7.4
Date: 2004-02-12 22:06:26
Message-ID: 20040212220626.GB905@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bjoern Metzdorf 2004-02-12 22:18:09 Re: No space left on device
Previous Message Mike Johnson 2004-02-12 22:01:25 Re: Showing all groups