It appears that you are only doing for "select" statements.  Are you expecting "select" to be done on 
your replicas?

Slony replicates data, not queries that only display existing data.

If you are doing inserts, updates or deletes of data on your main node, you should expect to see those 
changes on nodes 2 & 3.  Are you seeing any insert/update/delete activity done on node 1 showing up on 
nodes 2 & 3?

-Jennifer Spencer

Daniel Romero wrote:
> Hi.
> 
> I have 3 nodes, 1 main and 2 direct replicas.
> 
> I can see my querys in the main node log, but node 2 and 3 are not receiving
> any querys, only synch or "slony internal" querys.
> 
> 
> Any ideas?
> 
> 
> NODE 2 LOG EXAMPLE
> LOG:  statement: start transaction;set transaction isolation level
> serializable;select last_value from "_romeroCLT".sl_action_seq;
> LOG:  statement: rollback transaction;
> LOG:  statement: start transaction; set transaction isolation level
> serializable;
> LOG:  statement: select ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid,
> ev_xip,        ev_type,        ev_data1, ev_data2, ev_data3,
> ev_data4,        ev_data5, ev_data6, ev_data7, ev_data8 from
> "_romeroCLT".sl_event where  ev_origin = '2'        and ev_seqno > '33'
> order by ev_seqno
> LOG:  statement: commit transaction
> LOG:  statement: start transaction; set transaction isolation level
> serializable;
> LOG:  statement: select ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid,
> ev_xip,        ev_type,        ev_data1, ev_data2, ev_data3,
> ev_data4,        ev_data5, ev_data6, ev_data7, ev_data8 from
> "_romeroCLT".sl_event where  ev_origin = '2'        and ev_seqno > '34'
> order by ev_seqno
> LOG:  statement: rollback transaction;
> LOG:  statement: start transaction;set transaction isolation level
> serializable;select last_value from "_romeroCLT".sl_action_seq;
> LOG:  statement: rollback transaction;
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general