Thread: DBMirror - Replicating binary objects of type bytea ?
Anyone has a clue of why the replication using DBMirror (PostgreSQL 7.3.4)
does not replicate correctly if the primary key is of type "bytea" ?
Error message from DBMirror.pl is e.g. ERROR: Cannot insert a duplicate key into unique index payment_pkey
Second question: Is a "manual" failover setup possible and recommended using DBMirror?
Any experiences out there?
Thanks,
Rudolf VanderLeeden
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