--- On Thu, 6/11/08, Anoop Bhat <[EMAIL PROTECTED]> wrote: > 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. >
Are the slons running? And if so looking in the logs is a good start. > 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. > Make a change to a replicated table, then go check it on the slave. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
