Re: DBMirror - Replicating binary objects of type bytea ?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: DBMirror - Replicating binary objects of type bytea ?
Дата
Msg-id 20030821145302.GC9803@libertyrms.info
обсуждение исходный текст
Ответ на DBMirror - Replicating binary objects of type bytea ?  ("VanderLeeden" <vanderleeden@logicunited.com>)
Список pgsql-admin
On Wed, Aug 20, 2003 at 05:34:26PM +0200, VanderLeeden wrote:
> Second question:  Is a "manual" failover setup possible and
> recommended using DBMirror?

I haven't used dbmirror, but I would never[1] fail over automatically
from an asynchronous system.

Some suggestions on fail over:

1.    Make sure your sequences are up to date.  This is the sort of
thing you need to build a script for in advance.

2.    It's good to have a policy about how much data you can afford
to lose.  If the answer is, "none", you need to invest in some very
expensive hardware.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


В списке pgsql-admin по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Incremental Backup
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: This table won't use INDEX until I DUMP/RESTORE it ?