Christopher Browne wrote:
Alan Hodgson <[EMAIL PROTECTED]> writes:
On Monday 09 June 2008, Geoffrey <[EMAIL PROTECTED]> wrote:
I've got a number of sequences that are to be replicated in our
databases. I understand that sequences are special one row tables, but
I don't see any triggers on my master node sequences that would cause
the values to be replicated.
How is this handled in Slony?
I believe it just copies over the current sequence values on every sync, but
I could be wrong. Obviously, they have to be part of the replication set
for this to happen.
They are essentially handled via polling; every time a SYNC is
processed, we pull all of the replicated sequence values.
In v2.0, the values get pulled each time; we only pass on an update
when the sequence actually changes.
So then I assume that I don't need to worry about replication_role
values with regard to replicating sequences, since there are no triggers
involved.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
