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