[Pgcluster-general] Table requirements

Gábriel Ákos akos.gabriel at i-logic.hu
Thu May 17 16:22:40 UTC 2007


Hi,

I'd like (for documentational purposes) have an exact statement about
what a table has to look like to be replicated properly by pgcluster?
As far as I learned some kind of unique key has to be there.
Can this be a simple "composite key" of - say - the columns of the
table? For example I have a table with 2 string columns (name, role).
This is not replicated correctly by default. As far as I learned by
generating a composite key (name+role) it won't work either. By adding
an (otherwise meaningless) unique id, generated by a sequence, the
table will be replicated correctly.

Thanks for your help!

-- 
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos.gabriel at i-logic.hu|Web:  http://www.i-logic.hu =-
-=Tel/fax:+3612367353            |Mobil:+36209278894          =-


More information about the Pgcluster-general mailing list