| From: | Hervé Piedvache <herve(at)elma(dot)fr> |
|---|---|
| To: | "Gregory Wood" <gregw(at)com-stock(dot)com>, "Andrew Sullivan" <andrew(at)libertyrms(dot)info> |
| Cc: | "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: rserv replication error |
| Date: | 2003-02-26 19:19:17 |
| Message-ID: | 20030226192521.711214180C@mailer.elma.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Le Mercredi 26 Février 2003 19:42, Gregory Wood a écrit :
> > 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.
Same for me here ... Using DBmirror since 3 months ... and no primary key on
all my table !
Regards,
--
Hervé Piedvache
Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Tel. 33-144949901
fax. 33-144949902
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Medi Montaseri | 2003-02-26 19:31:38 | Re: 7.4? |
| Previous Message | Gregory Wood | 2003-02-26 18:42:00 | Re: rserv replication error |