Re: reduce downtime when upgrading 7.3 -> 7.4

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: reduce downtime when upgrading 7.3 -> 7.4
Дата
Msg-id 20040212220626.GB905@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: reduce downtime when upgrading 7.3 -> 7.4  (Christopher Browne <cbbrowne@acm.org>)
Список 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 по дате отправления:

Предыдущее
От: Bjoern Metzdorf
Дата:
Сообщение: Re: No space left on device
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: hanging for 30sec when checkpointing