Mon Jun 9 13:56:19 PDT 2008
- Previous message: [Slony1-general] What mechanism actually causes replication?
- Next message: [Slony1-general] What mechanism actually causes replication?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] What mechanism actually causes replication?
- Next message: [Slony1-general] What mechanism actually causes replication?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list