Christopher Browne wrote:

In a sense, it's *ALL* a big indirection.

Slony-I started by implementing an event management system, to get
events propagating between the nodes.

Once you've got that, replicating data is a convenient side-effect
:-).

Having replication working requires several things cooperating...

- The "logtrigger" triggers running on the origin collect data into
  sl_log_*.

- You need to have a slon working against the origin, marking off SYNC
  events every so often, which allows us to do incremental processing
  of replication data.

- The slon process connected to the subscriber listens for SYNC
  events, which tell it "Hey, we may have some new data for you!"
  SYNC information allows the subscriber to identify which data to
  look for in sl_log_*.

At the end of all that, you have replication.

I'm learning more then I ever wanted to about Slony. ;) Thanks again Christopher for your detailed response.

What I'm trying to avoid is the situation we had the last time we tried setting up Slony. At that time, we were on 7.4.19 Postgresql and we would 'disable all triggers' while our distributed database process did it's thing. The problem was, this would cause our replication subscriber to get out of sync with the origin.

The expectation is that if we set the 'right slony triggers' to 'fire always' we can avoid this issue and take advantage of the 'SET session_replication_role' functionality in Postgresql 8.3, we can eliminate our original problem with the earlier 7.4 Postgresql.

My problem is, defining the 'right slony triggers.'

From the perspective of Slony is it sufficient to insure the 'logtrigger' triggers fire? As those are the only triggers I see on the replicated tables, I assume that is the case. You know what they say about assumptions though.


--
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

Reply via email to