No, this is on the master. --Rob
From: Melvin Davidson <[email protected]<mailto:[email protected]>> Reply-To: Melvin Davidson <[email protected]<mailto:[email protected]>> Date: Monday, February 29, 2016 at 10:32 AM To: Rob Brucks <[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Re: [Slony1-general] Replication Lag? Which server are you executing the query on? If you are executing on the master, then this definitely looks like a bug. Otherwise, if you are executing on a slave, then I would say that is the source of the problem. Melvin Davidson Cell 720-320-0155 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. [http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif] www.youtube.com/unusedhero Folk Alley - All Folk - 24 Hours a day www.folkalley.com ________________________________ From: Rob Brucks <[email protected]<mailto:[email protected]>> To: Melvin Davidson <[email protected]<mailto:[email protected]>>; "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Sent: Monday, February 29, 2016 11:00 AM Subject: Re: [Slony1-general] Replication Lag? Everything is running on the same server. One subscriber instance has been shut down. test_db=# select * from _sloncluster.sl_status; -[ RECORD 1 ]-------------+------------------------------ st_origin | 1 st_received | 3 st_last_event | 5000000264 st_last_event_ts | 2016-02-29 09:58:24.455544-06 st_last_received | 5000000175 st_last_received_ts | 2016-02-29 09:43:47.461217-06 st_last_received_event_ts | 2016-02-29 09:43:38.254386-06 st_lag_num_events | 89 st_lag_time | 00:14:55.35601 -[ RECORD 2 ]-------------+------------------------------ st_origin | 1 st_received | 2 st_last_event | 5000000264 st_last_event_ts | 2016-02-29 09:58:24.455544-06 st_last_received | 5000000176 st_last_received_ts | 2016-02-29 09:43:52.284371-06 st_last_received_event_ts | 2016-02-29 09:43:48.258894-06 st_lag_num_events | 88 st_lag_time | 00:14:45.351502 Thanks, --Rob
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
