Fri Nov 7 05:25:22 PST 2008
- Previous message: [Slony1-general] Sl_status
- Next message: [Slony1-general] Sl_status
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
--- On Thu, 6/11/08, Anoop Bhat <ABhat at trustwave.com> 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.
- Previous message: [Slony1-general] Sl_status
- Next message: [Slony1-general] Sl_status
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list