Ed L. pgsql
Wed Oct 27 06:22:05 PDT 2004
On Tuesday October 26 2004 10:56, Jan Wieck wrote:
> Sequences replicated by Slony do not follow exactly the same semantics
> as tables. Each time a SYNC event is generated on the origin of data,
> the current values of all sequences is recorded. because of the
> difference in concurrency and visibility of changes between tables and
> sequences, these recorded values might include changes to the sequence
> that are not yet visible (committed) and therefore the corresponding
> table data changes will not yet get replicated with that SYNC event.
> Since sequences in PostgreSQL are not guaranteed to be gap free and
> don't roll back, this is acceptable. The do get correctly adjusted on
> switchover and they might be more advanced due to lost transactions in
> the case of a failover. So they follow exactly the PostgreSQL sequence
> semantics.

If I'm reading you correctly, I think you're saying that sequences will be 
not syncronized between master and slave until failover.  Is that correct?

Ed




More information about the Slony1-general mailing list