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
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 |