No, this is on the master.

--Rob

From: Melvin Davidson <melvin6925 at yahoo.com<mailto:melvin6925 at yahoo.com>>
Reply-To: Melvin Davidson <melvin6925 at yahoo.com<mailto:melvin6925 at yahoo.com>>
Date: Monday, February 29, 2016 at 10:32 AM
To: Rob Brucks <rob.brucks at rackspace.com<mailto:rob.brucks at rackspace.com>>, "slony1-general at lists.slony.info<mailto:slony1-general at lists.slony.info>" <slony1-general at lists.slony.info<mailto:slony1-general at lists.slony.info>>
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 <rob.brucks at rackspace.com<mailto:rob.brucks at rackspace.com>>
To: Melvin Davidson <melvin6925 at yahoo.com<mailto:melvin6925 at yahoo.com>>; "slony1-general at lists.slony.info<mailto:slony1-general at lists.slony.info>" <slony1-general at lists.slony.info<mailto: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                 | 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


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