I have a simple master/single-slave (ur, origin/single-subscriber)
configuration that I'm testing.

I've noticed that the origin slon process (node_1) opens a connection to
the subscriber database (node_2) and listens on three different
NOTIFY's:
    _cluster_Event
    _cluster_Confirm
    _cluster_Node_1

Why does the provider need to LISTEN for a notification on the
subscriber?  What does the subscriber do that the origin needs to know
about?  

I think that the subscriber sends a confirmation to the origin, but that
NOTIFY executes on the origin end doesn't it?

If the origin didn't need to LISTEN for notifications that execute in
the subscriber database, it wouldn't need a path (or a connection) to
the subscriber.

I have a feeling I'm missing something important here...

TIA.

   ++ Murphy





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050302/7cedfe71/attachment.html