Dmitry Koterov dmitry at koterov.ru
Tue May 22 10:05:56 PDT 2007
Hello.

Assume I perform an UPDATE for some replicated table: UPDATE tbl SET
field=3D'abcd' WHERE id=3D10. A Slony master creates an event for this upda=
te,
and each slave pulls this event and performs the replication process. The
question is: where Slony really stores an information about what data was
changed and to what it was changed?

I browsed sl_event table (and all other), but did not find any data field
containing the real "abcd" string. Seems there is no table inside the Slony
schema which holds that string "abcd". Strange! But how could it be? How
slaves know which data has to be updated while a replication process?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070522/=
8884817c/attachment.htm


More information about the Slony1-general mailing list