Christopher Browne cbbrowne at ca.afilias.info
Mon Jun 9 13:56:19 PDT 2008
Alan Hodgson <ahodgson at simkin.ca> writes:
> On Monday 09 June 2008, Geoffrey <lists at serioustechnology.com> 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.
-- 
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://linuxdatabases.info/info/nonrdbms.html
I found out why  cats drink out of the toilet. My  mother told me it's
because it's cold in there. And I'm like: How did my mother know THAT?
--Wendy Liebman


More information about the Slony1-general mailing list