Re: rserv replication error - Mailing list pgsql-general

From Gregory Wood
Subject Re: rserv replication error
Date
Msg-id 05bb01c2ddc6$c12f97a0$4f89ffcc@eng3
Whole thread Raw
In response to rserv replication error  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: rserv replication error  (Hervé Piedvache <herve@elma.fr>)
Re: rserv replication error  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
> One thing I do notice about dbmirror is that it requires a
> single-column primary key on every replicated table.  I bet you could
> hack it to use some other not null unique column, though.

Are you sure about that? We're using it right now on several tables with
multi-column primary keys with no problems.

There used to be a problem with tables that had _no_ primary key, but the
developer (Steve Singer IIRC) fixed that, at least in so far as it no longer
crashes. I don't know if it actually replicates those tables since I got
primary keys added to all our *ahem* unnormalized tables.

Greg


pgsql-general by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Re: Join query crashes 7.3.1 backend...
Next
From: Hervé Piedvache
Date:
Subject: Re: rserv replication error