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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110