[check_postgres] [commit] Put in a good ORDER BY for txn_wraparound

[check_postgres at bucardo.org]

Committed by Greg Sabino Mullane <greg at endpoint.com>

Put in a good ORDER BY for txn_wraparound

---
 check_postgres.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/check_postgres.pl b/check_postgres.pl
index d25c8cc..60efe20 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -2958,7 +2958,7 @@ sub check_txn_wraparound {
 		  default_critical => 1_400_000_000,
 		  });
 
-	$SQL = q{SELECT datname, age(datfrozenxid) FROM pg_database WHERE datallowconn is true};
+	$SQL = q{SELECT datname, age(datfrozenxid) FROM pg_database WHERE datallowconn is true ORDER BY 2 desc, 1};
 	my $info = run_command($SQL, { regex => qr[\w+\s+\|\s+\d+] } );
 
 	my ($max,$maxmsg) = (0,'?');
-- 
1.5.5.4