Thu Nov 6 12:13:05 PST 2008
- Previous message: [Slony1-general] Problem on Failover
- Next message: [Slony1-general] Sl_status
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, I learned from cbrowne that I can query sl_status to find out the status of the replication. Within a minute or so, the origin's sl_status for the cluster I created looked like this st_origin | st_received | st_last_event | st_last_event_ts | st_last_received | st_last_received_ts | st_last_received_event_ts | st_lag_num_events | st_lag_time -----------+-------------+---------------+----------------------------+------------------+----------------------------+----------------------------+-------------------+----------------- 1 | 2 | 35 | 2008-11-06 20:02:24.943084 | 35 | 2008-11-06 14:07:11.002322 | 2008-11-06 20:02:24.943084 | 0 | 00:00:06.259891 st_last_event and st_last_received grew. However, I'm not sure what's being replicated and if it's going into the right tables in the slave db. The db's are called vul and vul_slave. On vul_slave, what can I check on to see if it's gotten any data. I used the slony docs this time to set it up just to make sure it was done right. I noticed this by the way on http://www.slony.info/documentation/firstdb.html # subscribe set to second node (1= set ID, 2= node ID) $ slonik_subscribe_set 2 | slonik Is that command missing an option? Thanks Anoop
- Previous message: [Slony1-general] Problem on Failover
- Next message: [Slony1-general] Sl_status
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list