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. 
www.youtube.com/unusedhero
 Folk Alley - All Folk - 24 Hours a day 
www.folkalley.com




      From: Rob Brucks <rob.brucks at rackspace.com>
 To: Melvin Davidson <melvin6925 at yahoo.com>; "slony1-general at lists.slony.info" <slony1-general at lists.slony.info> 
 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                 | 1st_received               | 3st_last_event             | 5000000264st_last_event_ts          | 2016-02-29 09:58:24.455544-06st_last_received          | 5000000175st_last_received_ts       | 2016-02-29 09:43:47.461217-06st_last_received_event_ts | 2016-02-29 09:43:38.254386-06st_lag_num_events         | 89st_lag_time               | 00:14:55.35601-[ RECORD 2 ]-------------+------------------------------st_origin                 | 1st_received               | 2st_last_event             | 5000000264st_last_event_ts          | 2016-02-29 09:58:24.455544-06st_last_received          | 5000000176st_last_received_ts       | 2016-02-29 09:43:52.284371-06st_last_received_event_ts | 2016-02-29 09:43:48.258894-06st_lag_num_events         | 88st_lag_time               | 00:14:45.351502
Thanks,--Rob

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20160229/2a01ae0c/attachment.htm