Home > mailing lists

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

From	VanderLeeden
Subject	DBMirror - Replicating binary objects of type bytea ?
Date	August 20, 2003 21:16:56
Msg-id	011201c36730$8e270980$2201a8c0@gsr.hp.com Whole thread Raw
Responses	Re: DBMirror - Replicating binary objects of type bytea ?
List	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

From: "dan"
Date: 20 August 2003, 20:17:09
Subject: Help with pg_restore

From: Tom Lane
Date: 20 August 2003, 21:31:08
Subject: Re: Help with pg_restore