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
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
