DBMirror - Replicating binary objects of type bytea ?

From: "VanderLeeden" <vanderleeden(at)logicunited(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: "VanderLeeden" <vanderleeden(at)t-online(dot)de>
Subject: DBMirror - Replicating binary objects of type bytea ?
Date: 2003-08-20 15:34:26
Message-ID: 011201c36730$8e270980$2201a8c0@gsr.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Logic United GmbH, Munich, Germany
Phone +4980-249-2933
www.logicunited.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-08-20 15:45:46 Re: Explicit Cast
Previous Message Mendola Gaetano 2003-08-20 15:19:11 Re: Explicit Cast