Hi. Problem solved.
Cause: slonik_init_cluster is not generating the "STORE PATH" commands. Ej: store path (server = 1, client = 2, conninfo='dbname=romero host=192.168.xxx.194 user=postgres'); Solution: create a new missingCommand.sh script as follow: #!/bin/sh slonik <<_EOF_ cluster name = romeroCLT; node 1 admin conninfo='host=192.168.xxx.194 dbname=romero user=postgres port=5432'; node 2 admin conninfo='host=192.168.xxx.195 dbname=romero user=postgres port=5432'; node 3 admin conninfo='host=192.168.xxx.196 dbname=romero user=postgres port=5432'; # STORE PATH echo 'Next: configure paths for each node/origin'; store path (server = 1, client = 2, conninfo='dbname=romero host=192.168.xxx.194 user=postgres'); store path (server = 1, client = 3, conninfo='dbname=romero host=192.168.xxx.194 user=postgres'); echo 'Replication nodes prepared'; echo 'Please start a slon replication daemon for each node'; _EOF_ -- Regards, Daniel Romero P. NICLabs (www.niclabs.cl) 2008/11/14 Jennifer Spencer <[EMAIL PROTECTED]> > 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
