Re: DBMirror - Replicating binary objects of type bytea ? - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: DBMirror - Replicating binary objects of type bytea ?
Date
Msg-id 20030821145302.GC9803@libertyrms.info
Whole thread Raw
In response to DBMirror - Replicating binary objects of type bytea ?  ("VanderLeeden" <vanderleeden@logicunited.com>)
List 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 by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Incremental Backup
Next
From: Stephan Szabo
Date:
Subject: Re: This table won't use INDEX until I DUMP/RESTORE it ?