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 <[email protected]>
To: Melvin Davidson <[email protected]>; "[email protected]"
<[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 |
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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
