Re: DBMirror - Replicating binary objects of type bytea ?

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