X-Git-Url: https://git.8kb.co.uk/?p=slony-i%2Fpgbouncer_follower;a=blobdiff_plain;f=pgbouncer_follower.pl;h=51ba2d09abce8833744dbd8a9781fac8fe7f031e;hp=23eabcd068cab5b2301bbc4529bc6f4f67ced748;hb=ba91f4cb29608c6018f4cb0c1d07b246074fc0d0;hpb=399f595661a3c583cdd16d18e4da7ad6ea089393 diff --git a/pgbouncer_follower.pl b/pgbouncer_follower.pl index 23eabcd..51ba2d0 100755 --- a/pgbouncer_follower.pl +++ b/pgbouncer_follower.pl @@ -544,10 +544,18 @@ sub loadBinCluster { } # Do the post processing we mentioned above, once we know xlog locations differ # then we can say the apply lag is correct, else it's just there has been no - # activity on the master. + # activity on the master. In the case the xlog locations differ but apply_lag + # is 0 then it means no WAL has been applied since srver start; cludge here + # and set lag to 1 week. else { foreach (@tmp_cluster) { - $apply_lag = ((@$_[12] > 0 && @$_[11] != $primary_location) ? @$_[12] : 0); + if (@$_[11] eq $primary_location) { + $apply_lag = 0; + } + else { + $apply_lag = @$_[12] if (@$_[12] > 0); + $apply_lag = 604800 if (@$_[12] = 0); + } my @node=(@$_[0],@$_[1],@$_[2],@$_[3],@$_[4],@$_[5],@$_[6],@$_[7],@$_[8],@$_[9],@$_[10],$apply_lag); push(@cluster, \@node); }